Question

In: Accounting

Problem 23-2A Preparation and analysis of a flexible budget performance report LO P1, P2, A1 Phoenix...

Problem 23-2A Preparation and analysis of a flexible budget performance report LO P1, P2, A1 Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an expected production and sales volume of 18,000 units. PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2017 Sales $ 4,050,000 Cost of goods sold Direct materials $ 990,000 Direct labor 270,000 Machinery repairs (variable cost) 72,000 Depreciation—Plant equipment (straight-line) 315,000 Utilities ($54,000 is variable) 214,000 Plant management salaries 215,000 2,076,000 Gross profit 1,974,000 Selling expenses Packaging 90,000 Shipping 126,000 Sales salary (fixed annual amount) 260,000 476,000 General and administrative expenses Advertising expense 126,000 Salaries 251,000 Entertainment expense 90,000 467,000 Income from operations $ 1,031,000 Phoenix Company’s actual income statement for 2017 follows. PHOENIX COMPANY Statement of Income from Operations For Year Ended December 31, 2017 Sales (21,000 units) $ 4,788,000 Cost of goods sold Direct materials $ 1,172,000 Direct labor 323,000 Machinery repairs (variable cost) 75,000 Depreciation—Plant equipment (straight-line) 315,000 Utilities (fixed cost is $157,500) 219,750 Plant management salaries 225,000 2,329,750 Gross profit 2,458,250 Selling expenses Packaging 102,500 Shipping 139,000 Sales salary (annual) 276,000 517,500 General and administrative expenses Advertising expense 134,000 Salaries 251,000 Entertainment expense 93,500 478,500 Income from operations $ 1,462,250 Required: 1. Prepare a flexible budget performance report for 2017

Solutions

Expert Solution

Solution:

Phoenix Company
Flexible Budget Performance Report
For the year ended Dec 31, 2017
Particulars Flexible Budget Actual results Variances Fav. / Unfav.
Sales $4,725,000.00 $4,788,000.00 $63,000.00 Favorable
Variable Costs:
Direct Materials $1,155,000.00 $1,172,000.00 $17,000.00 Unfavorable
Direct Labor $315,000.00 $323,000.00 $8,000.00 Unfavorable
Machinery Repairs $84,000.00 $75,000.00 $9,000.00 Favorable
Utilities $63,000.00 $62,250.00 $750.00 Favorable
Packaging $105,000.00 $102,500.00 $2,500.00 Favorable
Shipping $147,000.00 $139,000.00 $8,000.00 Favorable
Total Variable Costs: $1,869,000.00 $1,873,750.00 $4,750.00 Unfavorable
Contribution $2,856,000.00 $2,914,250.00 $58,250.00 Favorable
Fixed Costs:
Depreciation - Plant & Equipment $315,000.00 $315,000.00 $0.00 Neither favorable nor unfavorable
Utilities $160,000.00 $157,500.00 $2,500.00 Favorable
Plant mangement salaries $215,000.00 $225,000.00 $10,000.00 Unfavorable
Sales Salary $260,000.00 $276,000.00 $16,000.00 Unfavorable
Advertising Expense $126,000.00 $134,000.00 $8,000.00 Unfavorable
Salaries $251,000.00 $251,000.00 $0.00 Neither favorable nor unfavorable
Entertainment Expenses $90,000.00 $93,500.00 $3,500.00 Unfavorable
Total Fixed Costs $1,417,000.00 $1,452,000.00 $35,000.00 Unfavorable
Net Operating Income $1,439,000.00 $1,462,250.00 $23,250.00 Favorable

Related Solutions

Problem 23-2A Preparation and analysis of a flexible budget performance report LO P1, P2, A1 Phoenix...
Problem 23-2A Preparation and analysis of a flexible budget performance report LO P1, P2, A1 Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an expected production and sales volume of 16,000 units. PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2017 Sales $ 3,200,000 Cost of goods sold Direct materials $ 960,000 Direct labor 240,000 Machinery repairs (variable cost) 48,000 Depreciation—Plant equipment (straight-line) 315,000 Utilities ($32,000 is variable) 182,000 Plant management...
Problem 22-4A Manufacturing: Preparation of a complete master budget LO P1, P2, P3 The management of...
Problem 22-4A Manufacturing: Preparation of a complete master budget LO P1, P2, P3 The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017: ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2017 Assets Cash $ 53,000 Accounts receivable 392,400 Raw materials inventory 96,600 Finished goods inventory 313,920 Total current assets 855,920 Equipment, gross 626,000 Accumulated depreciation (163,000 ) Equipment, net 463,000 Total assets $ 1,318,920 Liabilities and Equity Accounts payable $ 204,800 Short-term notes payable 25,000 Total...
Problem 20-4A Manufacturing: Preparation of a complete master budget LO P1, P2, P3 The management of...
Problem 20-4A Manufacturing: Preparation of a complete master budget LO P1, P2, P3 The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017: ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2017 Assets Cash $ 65,000 Accounts receivable 434,850 Raw materials inventory 87,505 Finished goods inventory 374,640 Total current assets 961,995 Equipment, gross 624,000 Accumulated depreciation (162,000 ) Equipment, net 462,000 Total assets $ 1,423,995 Liabilities and Equity Accounts payable $ 199,405 Short-term notes payable 24,000 Total...
Problem 20-4A Manufacturing: Preparation of a complete master budget LO P1, P2, P3 The management of...
Problem 20-4A Manufacturing: Preparation of a complete master budget LO P1, P2, P3 The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017: ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2017 Assets Cash $ 80,000 Accounts receivable 364,000 Raw materials inventory 96,000 Finished goods inventory 364,800 Total current assets 904,800 Equipment, gross 610,000 Accumulated depreciation (155,000 ) Equipment, net 455,000 Total assets $ 1,359,800 Liabilities and Equity Accounts payable $ 195,500 Short-term notes payable 17,000 Total...
Exercise 23-6 Preparing a flexible budget report LO P1 Lewis Co. reports the following results for...
Exercise 23-6 Preparing a flexible budget report LO P1 Lewis Co. reports the following results for May. Prepare a flexible budget report showing variances between budgeted and actual results. Budgeted Actual Sales $ 1,050 per unit $ 1,678,000 Variable expenses $ 420 per unit $ 652,000 Fixed expenses (total) $ 147,500 $ 137,000 Units produced and sold 1,350 1,550 List variable and fixed expenses separately. (Indicate the effect of each variance by selecting for favorable, unfavorable, and no variance) LEWIS...
GL0502 - Based on Problem 5-2A Lowe's Company LO P1, P2 Prepare journal entries to record...
GL0502 - Based on Problem 5-2A Lowe's Company LO P1, P2 Prepare journal entries to record the following merchandising transactions of Lowe’s, which uses the perpetual inventory system. (Hint: It will help to identify each receivable and payable; for example, record the purchase on August 1 in Accounts Payable—Aron.) Aug. 1 Purchased merchandise from Aron Company for $7,500 under credit terms of 1/10, n/30, FOB destination, invoice dated August 1. Aug. 5 Sold merchandise to Baird Corp. for $5,200 under...
Problem 2-2A Preparing and posting journal entries; preparing a trial balance LO C3, C4, A1, P1,...
Problem 2-2A Preparing and posting journal entries; preparing a trial balance LO C3, C4, A1, P1, P2 Aracel Engineering completed the following transactions in the month of June. Jenna Aracel, the owner, invested $200,000 cash, office equipment with a value of $5,400, and $60,000 of drafting equipment to launch the company. The company purchased land worth $53,000 for an office by paying $9,200 cash and signing a long-term note payable for $43,800. The company purchased a portable building with $58,000...
Problem 2-2A Preparing and posting journal entries; preparing a trial balance LO C3, C4, A1, P1,...
Problem 2-2A Preparing and posting journal entries; preparing a trial balance LO C3, C4, A1, P1, P2 Aracel Engineering completed the following transactions in the month of June. Jenna Aracel, the owner, invested $185,000 cash, office equipment with a value of $9,200, and $73,000 of drafting equipment to launch the company. The company purchased land worth $51,000 for an office by paying $6,900 cash and signing a long-term note payable for $44,100. The company purchased a portable building with $55,000...
Problem 2-2A Preparing and posting journal entries; preparing a trial balance LO C3, C4, A1, P1,...
Problem 2-2A Preparing and posting journal entries; preparing a trial balance LO C3, C4, A1, P1, P2 Aracel Engineering completed the following transactions in the month of June. Jenna Aracel, the owner, invested $200,000 cash, office equipment with a value of $5,400, and $60,000 of drafting equipment to launch the company. The company purchased land worth $53,000 for an office by paying $9,200 cash and signing a long-term note payable for $43,800. The company purchased a portable building with $58,000...
Question: Problem 20-4B Manufacturing: Preparation of a complete master budget P1 P2 P3 The management of...
Question: Problem 20-4B Manufacturing: Preparation of a complete master budget P1 P2 P3 The management of N... Using an "EXCEL" spreadsheet, create budgets (Items 1-9). Problem 20-4B Manufacturing: Preparation of a complete master budget P1 P2 P3 The management of Nabar Manufacturing prepared the following estimated balance sheet for June, 2015: NABAR MANUFACTURING Estimated Balance Sheet June 30, 2015 Assets Liabilities and Equity $ 40,000 ...249.900 35,000 Accounts receivable Raw materials inventory Finished goods inventory Total current assets Equipment, gross...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT