Question

E8-15 Preparing Budgeted Income Statement [LO 8-3h] Ceder Company has compiled the following data for the...

E8-15 Preparing Budgeted Income Statement [LO 8-3h]

Ceder Company has compiled the following data for the upcoming year:

  • Sales are expected to be 12,000 units at $51.00 each.
  • Each unit requires 2 pounds of direct materials at $3.10 per pound.
  • Each unit requires 1.9 hours of direct labor at $14.00 per hour.
  • Manufacturing overhead is $4.10 per unit.
  • Beginning raw materials inventory is $4,600.00.
  • Ending raw materials inventory is $5,750.00.
  • Selling and administrative costs totaled $137,520.


Required:
1.
Determine Ceder's budgeted cost of goods sold. (Do not round the intermediate values.)



2. Complete Ceder's budgeted income statement. (Do not round the intermediate values.)

References

eBook & Resources

Homework Answers

Answer #1

Solution: Requirement 1.

Ceder Company

Computation of budgeted cost of goods sold

Particulars Amount
Direct Material (2 * $3.10 * 12,000) $74,400
Direct labor (1.9 * $14 * 12,000) $319,200
Manufacturing overhead ($4.10 * 12,000) $49,200
Budgeted Cost of Goods Sold $442,800

Requirement 2.

Budgeted Income Statement

Sales (12,000 * $51) $612,000
Less: Budgeted Cost of Goods Sold $442,800
Gross Profit $169,200
Less: Selling and administrative costs $137,520
Budgeted Net Income $31,680

Please rate positive and comment in case of any doubt. I would be happy to help you further.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
apcaplett, Inc. has the following budgeted income statement for January and February: January February Revenues $1,200,000...
apcaplett, Inc. has the following budgeted income statement for January and February: January February Revenues $1,200,000 $1,100,000 Direct Materials 220,000 202,000 Other Variable COGS 140,000 128,000 Fixed COGS 300,000 300,000 Gross Margin $ 540,000 $ 470,000 Period Costs (Fixed) 380,000 380,000 Income $ 160,000 $ 90,000 Wapcaplett has noticed the following trends: 20% of all sales are in cash, and the other 80% are credit sales. Credit sales are collected 75% in the month of the sale and 25% in...
Problem 9-4 Karam Inc. has compiled the following data in order to put together their first...
Problem 9-4 Karam Inc. has compiled the following data in order to put together their first quarter operating budget for 2011: January February March April Sales (units) 35,000 31,000 38,000 29,000 Each unit requires three hours of direct labor. Additional information: Karam sells each unit for $95. Company policy is to have 30 percent of next month's sales (in units) in ending finished goods inventory. Company policy is to have 40 percent of next month's production needs in ending raw...
ZIRA CO. Direct Materials Budget For April, May, and June April May June Budgeted production (units)...
ZIRA CO. Direct Materials Budget For April, May, and June April May June Budgeted production (units) 694 735 727 units Materials requirements per unit 4 4 4 lbs. Materials needed for production (lbs.) 2,776 2,940 2,908 lbs. Budgeted ending inventory (lbs.) 882 872 872 lbs. Total materials requirements (lbs.) 3,658 3,812 3,780 lbs. Beginning inventory (lbs.) 833 882 872 lbs. Materials to be purchased (lbs.) 2,825 2,930 2,908 lbs. Cost per lb. $4 $4 $4 per lb. Total budgeted direct...
Required information Use the following information for the Exercises below. Ruiz Co. provides the following sales...
Required information Use the following information for the Exercises below. Ruiz Co. provides the following sales forecast for the next four months:     April May June July Sales (units) 650 730 680 770 The company wants to end each month with ending finished goods inventory equal to 20% of next month's forecasted sales. Finished goods inventory on April 1 is 130 units. Assume July's budgeted production is 680 units. In addition, each finished unit requires six pounds (lbs.) of raw...
E5-3 Calculating Contribution Margin and Contribution Ratio, Preparing Contribution Margin Income Statement [LO 5-5] Morning Dove...
E5-3 Calculating Contribution Margin and Contribution Ratio, Preparing Contribution Margin Income Statement [LO 5-5] Morning Dove Company manufactures one model of birdbath, which is very popular. Morning Dove sells all units it produces each month. The relevant range is 0–2,500 units, and monthly production costs for the production of 2,200 units follow. Morning Dove’s utilities and maintenance costs are mixed with the fixed components shown in parentheses. Production Costs Total Cost Direct materials $ 1,500 Direct labor 6,700 Utilities ($130...
Problem 06-2A Variable costing income statement and conversion to absorption costing income LO P2, P3 Trez...
Problem 06-2A Variable costing income statement and conversion to absorption costing income LO P2, P3 Trez Company began operations this year. During this first year, the company produced 100,000 units and sold 80,000 units. The absorption costing income statement for this year follows. Sales (80,000 units × $45 per unit) $ 3,600,000 Cost of goods sold Beginning inventory $ 0 Cost of goods manufactured (100,000 units × $25 per unit) 2,500,000 Cost of goods available for sale 2,500,000 Ending inventory...
37. Advanced Company reports the following information for the current year. All beginning inventory amounts equaled...
37. Advanced Company reports the following information for the current year. All beginning inventory amounts equaled $0 this year. Units produced this year 33,000 units Units sold this year 19,800 units Direct materials $ 17 per unit Direct labor $ 19 per unit Variable overhead $ 99,000 in total Fixed overhead $ 165,000 in total Given Advanced Company's data, compute cost per unit of finished goods under variable costing. 44.Alliance Company's budgets production of 26,000 units in January and 30,000...
2. Zira Co. reports the following production budget for the next four months. April May June...
2. Zira Co. reports the following production budget for the next four months. April May June July Production (units) 656 710 688 668 Each finished unit requires six pounds of raw materials and the company wants to end each month with raw materials inventory equal to 30% of next month’s production needs. Beginning raw materials inventory for April was 1,181 pounds. Assume direct materials cost $5 per pound. Prepare a direct materials budget for April, May, and June. (Round your...
Problem 20-1A Manufacturing: Preparing production and manufacturing budgets LO C2, P1 [The following information applies to...
Problem 20-1A Manufacturing: Preparing production and manufacturing budgets LO C2, P1 [The following information applies to the questions displayed below.] Black Diamond Company produces snow skis. Each ski requires 2 pounds of carbon fiber. The company’s management predicts that 5,000 skis and 6,000 pounds of carbon fiber will be in inventory on June 30 of the current year and that 150,000 skis will be sold during the next (third) quarter. A set of two skis sells for $300. Management wants...
Budgeted Income Statement and Supporting Budgets The budget director of Birds of a Feather Inc., with...
Budgeted Income Statement and Supporting Budgets The budget director of Birds of a Feather Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for January: Estimated sales for January:   Bird house 6,000 units at $55 per unit   Bird feeder 4,500 units at $75 per unit Estimated inventories at January 1: Direct materials:   Wood 220 ft.   Plastic 250 lbs. Finished products:   Bird house 300...