Comfort Furniture Pty Ltd manufactures and distributes stylish and practical furniture for hospitality industry in Australia. The company’s balance sheet at December 31, 2016 is shown below:

 

Comfort Furniture Balance Sheet

December 31, 2016

 
Assets    
Current Assets    
Cash   $7,500
Accounts receivable   $73,500
Finished goods inventory (1500 units)   $24,000
Total current assets   $105,000
Property, plant and equipment    
Equipment $40,000  
Less: Accumulated depreciation $10,000 $30,000
Total Assets:   $135,000
     
Liabilities    
Notes payable   $25,000
Accounts payable   $45,000
Total Liabilities   $70,000
     
Stockholders’ Equity    
Common stock $40,000  
Retained earnings $25,000  
Total stockholders’ equity   $65,000
Total liabilities and stockholders’ equity   $135,000

 

 

Budgeted data for the year 2017 includes the following:

 

 

2017    
  Quarter 4 Total
Sales budget (8,000 units at $32) $76,800 $256,000
Direct materials used 17,000 62,500
Direct labour 12,500 50,900
Manufacturing overhead applied 10,000 48,600
Selling and administrative expenses 18,000 75,000

 

 

Additional Information:

 

To meet sales requirements and to have 2,500 units of finished goods on hand at December 31, 2017, the production budget shows 9,000 required units of output. The total unit cost of production is expected to be $18. The company uses the first-in, first out (FIFO) inventory costing method. Interest expense is expected to be $3,500 for the year. Income taxes are expected to be 40% of income before income taxes, in 2017, the company expects to declare and pay $8,000 cash dividends.

 

The company’s cash budget shows and expected cash balance of $5,880 at December 31, 2017. All sales and purchases are on account. It is expected that 60% of quarterly sales are collected in cash within the quarter and the remainder is collected in the following quarter. Direct materials purchased from suppliers and paid 50% in the quarter incurred and the remainder in the following quarter. Purchases in the fourth quarter were the same as the materials used. In 2017, the company expects to purchase additional equipment costing $9,000. $4,000 of depreciation expense on equipment is included in the budget data and split equally between manufacturing overhead and selling and administrative expenses.

 

The company expects to pay $8,000 on the outstanding notes payable balance plus all interest due and payable to December 31 (included in interest expense $3,500, above). Accounts payable at December 31,2017, includes amounts due suppliers (see above) plus other accounts payable of $7,200. Unpaid income taxes at December 31 will be $5,000.

 

Required: 

 

Prepare the following for 2017:

 

  • Budgeted statement of cost of goods sold (15 marks)
  • Budgeted multiple-step income statement (25 marks)
  • Retained earnings statement for 2017 (15 marks)
  • Budgeted classified balance sheet at December 31,2017 (25 marks)
  • Proof of budgeted cash balance at December 31, 2017 (20 marks)

 

Click on Buy Solution and make payment. All prices shown above are in USD. Payment supported in all currencies. Price shown above includes the solution of all questions mentioned on this page. Please note that our prices are fixed (do not bargain).

After making payment, solution is available instantly.Solution is available either in Word or Excel format unless otherwise specified.


If your question is slightly different from the above question, please contact us at info@myassignmentguru.com with your version of question.