Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Accounting Basics Expert

Perfect Gas Corporation supplies compressed gases to industry customers. Data regarding the store's operations follow:

• Sales are budgeted at $345,000 for November, $230,000 for December, and $320,000 for January.

• Collections are expected to be 60% in the month of sale, 34% in the month following the sale, and 6% uncollectible.

• The cost of goods sold is 70% of sales.

• The company desires ending merchandise inventory to equal 80% of the following month's cost of goods sold. Payment for merchandise is made in the month following the purchase.

• Other monthly expenses to be paid in cash are $12,000.

• Monthly depreciation is $16,000.

• Equipment purchases of $110,000 were paid in cash in November.

• Dividends of $35,000 were declared and paid in December.

• Any borrowings must be in $1,000 increments at 7% interest. Assume interest accrues at the beginning of the month and is paid at the end of the month. The company must maintain a minimum cash balance of $5,000.

• Ignore income taxes.

Prepare the following budgets for November and December and total for the two months in good form in excel and submit via bblearn by 5/9 at noon:

a. Prepare a Schedule of Expected Cash Collections

b. Prepare a Merchandise Purchases Budget

c. Prepare Cash Budgets

d. Prepare Budgeted Income Statements

e. Prepare a Budgeted Balance Sheet

Prepare a letter/memo to the company's CEO with specific recommendations regarding your budget.

Accounting Basics, Accounting

  • Category:- Accounting Basics
  • Reference No.:- M945752

Have any Question? 


Related Questions in Accounting Basics

Assignment descriptiona manufacturing company is thinking

Assignment Description A manufacturing company is thinking of launching a new product. The company expects to sell $950,000 of the new product in the first year and $1,500,000 each year thereafter. Direct costs including ...

Accounting questions1 if cash is 2345 in 20x2 and 3671 in

Accounting Questions 1. If Cash is $2,345 in 20X2 and $3,671 in 20X1, what is the percentage of increase or (decrease) from 20X1 to 20X2? A. 56.55%******* B. (56.55%) C. 36.12% D. (36.12%) 2. Gross profit by department a ...

Accounting information systems1 you have been asked by the

Accounting Information Systems 1. You have been asked by the CFO of the company where you work or previously worked to evaluate the use of a professional service organization for processing the company's payroll. Identif ...

The conference on evaluating capital projects has been very

The conference on evaluating capital projects has been very helpful. You have received a significant amount of information and multiple projects to evaluate to hone your skills. To adequately teach Grammy and the board y ...

The company uses a periodic inventory system for specific

The Company uses a periodic inventory system. For specific identification, ending inventory consists of 375 units, where 190 are from the January 30 purchase, 80 are from the January 20 purchase, and 105 are from beginni ...

Company annual report studychoose any company and make a

COMPANY ANNUAL REPORT STUDY Choose any company and make a report on financial report of company: David Jones Introduction (about 100 words) Conceptual framework (200 words) Critical analysis (200 words) Ethics (not more ...

Question 1the board of directors is considering updating

Question 1 The board of directors is considering updating the fleet of vehicles of the company which are used to ship goods to markets all around the United States. They will be leasing the vehicles as opposed to purchas ...

Discussion 1 and 2discussion 1select one of the following

Discussion 1 and 2 Discussion 1 Select one of the following tools: the nine steps in Ackerman and Anderson's roadmap for change, Cummings and Worley's five dimensions of leading and managing change, or the three componen ...

Accounting systems and assurance assessment internal

Accounting Systems and Assurance Assessment: Internal Control and information quality Accounting students learn how to process, analyse and use accounting information. It is also necessary to learn what contributes to th ...

Accountingcase to assess assurance of learning goal ethical

Accounting Case to assess Assurance of Learning Goal (Ethical Perspectives) Michael Greer is the Marketing Vice President for Atlantic Lubricants headquartered in Boston with extensive operations in New York City that se ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro