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

Illustrative question- shane brookson july 1 2015 shane

Illustrative Question- Shane Brooks On July 1, 2015, Shane Brooks established an interior decorating business, Premium Designs. During the month, the following transactions are completed: July  1. Transferred cash from a ...

Intercompany debt both long term and short term arises

Intercompany debt, both long term and short term, arises frequently. In some cases, intercorporate borrowings may arise because one affiliate can borrow at a cheaper rate than others, and lending to other affiliates may ...

Assignmentaccounting is the study of how businesses track

Assignment Accounting is the study of how businesses track their income and assets over time. Accountants engage in a wide variety of activities besides preparing financial statements and recording business transactions. ...

Question 1which entry would record the payment of a utility

Question 1 Which entry would record the payment of a utility bill? A. Debit Utilities Expense; credit Cash B. Debit Cash; credit Utilities Expense C. Debit Utilities Expense; credit Accounts Payable D. Debit Accounts Rec ...

Exercise 1north company has completed all of its operating

Exercise 1 North Company has completed all of its operating budgets. The sales budget for the year shows 50,120 units and total sales of $2,128,200. The total unit cost of making one unit of sales is $22. Selling and adm ...

Qestion 1beginning inventory24 tires 61purchase6 tires

QUESTION 1. Beginning inventory........24 tires @ $61 Purchase.........6 tires @ $76 Sale.......17 tires @ $105 Requirements 1. Compute cost of goods sold and gross profit under FIFO. 2. Compute cost of goods sold and gr ...

Assignment questionbesar ltd acquired all of the shares in

Assignment Question Besar Ltd acquired all of the shares in Kecil Ltd on 1 July 2015. At that date, equity of Kecil Ltd consisted of: Share Capital $2 000 000 Retained earnings 800 000 At 1 July 2015, all the assets and ...

Sarbanes oxley requires that per section 404 that internal

Sarbanes Oxley requires that per Section 404 that Internal Controls within a publicly held company are to be reviewed, evaluated and tested at year end to insure that adequate controls are in place. In addition to unders ...

This is a group work and i entitle do the cash flow

This is a group work and I entitle do the cash flow analysis for Home Depot. Please no more than two pages. Assume that your Group has been hired to serve as my new Investment Advisory Team. I am looking for new investme ...

Module 1 1 page topic selectionselect any topic in

Module 1 ( 1 Page ) Topic Selection Select any topic in accounting of interest that connects to the subject matter of this course. If you have already selected the area of your doctoral research, you may choose a topic i ...

  • 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