Question

In: Accounting

Eckert Company has budgeted the following unit sales:

Eckert Company has budgeted the following unit sales:

2016                             Units

                                    April                            25,000

                                    May                            50,000

                                    June                           75,000

                                    July                            45,000

Of the units budgeted, 40% are sold by the Southern Division at an average price of $15 per unit and the remainder are sold by the Eastern Division at an average price of $12 per unit. Instructions Prepare separate sales budgets for each division and for the company in total for the second quarter of 2017 by completing the chart. Do NOT use dollar signs.

Solutions

Expert Solution

Eckert Company
Sales Budget
for the second quarter of 2017
Eastern Division April May June Total
Expected unit sales 15,000
(25,000 x 60%)
30,000
(50,000 x 60%)
45,000
(75,000 x 60%)
90,000
Unit selling price 12 12 12 12
Total sales (A) 180,000 360,000 540,000 1,080,000
Southern Division April May June Total
Budgeted Unit sales 10,000
(25,000 x 40%)
20,000
(50,000 x 40%)
30,000
(75,000 x 40%)
60,000
Unit selling price 15 15 15 15
Total sales (B) 150,000 300,000 450,000 900,000
Total company sales
(A +B)
330,000 660,000 990,000 1,980,000

Related Solutions

Lubriderm Corporation has budgeted the following unit sales for the next four months: ​Month​​​ Unit Sales...
Lubriderm Corporation has budgeted the following unit sales for the next four months: ​Month​​​ Unit Sales ​ July​​​ 120,000 ​August​ ​​210,000 ​September​​ 150,000 ​October​​ 180,000 ​ Plans are to have an ending inventory of finished products that equals 20% of the unit sales for the next month. Five pounds of materials are required for each finished unit produced, and each pound of material costs $8. The desired ending inventory level for materials is equal to 30% of the materials needs...
A) Moriarity Company has budgeted the following unit sales: 1st Quarter 2019 7,000 2nd Quarter 2019...
A) Moriarity Company has budgeted the following unit sales: 1st Quarter 2019 7,000 2nd Quarter 2019 3,000 3rd Quarter 2019 4,000 Beginning finished goods for the first quarter was 1,400 units. The company's policy is to maintain an inventory of finished goods as 20% of the next quarter sales. The production budget for the SECOND quarter is __________. (no dollar signs, decimals or commas) HINT: you must calculate the first quarter in order to calculate the 2nd quarter. B)JTS Corp...
AH Corp has the following budgeted unit sales for the second half of the 2020: Month...
AH Corp has the following budgeted unit sales for the second half of the 2020: Month Unit Sales July 90,000 August 120,000 September 210,000 October 150,000 November 180,000 December 120,000 It is expected to have 30,000 units of finished goods in inventory at the beginning of budget period and the plans are to have an inventory of finished products that equal 20% of the unit sales for the next month. Five pounds of materials are required for each unit produced....
Coliseum Company has budgeted the following unit sales: Quarter Units Qtr. 1, 2020 60,000 Qtr. 2,...
Coliseum Company has budgeted the following unit sales: Quarter Units Qtr. 1, 2020 60,000 Qtr. 2, 2020 50,000 Qtr. 3, 2020 40,000 Qtr. 4, 2020 80,000 The finished goods inventory on hand on December 31, 2019 was 6,000 units. 90% of the next quarter’s sales will come from production during that quarter, and the remainder of next quarter’s sales will come from this quarter’s ending inventory. Required: Prepare a production budget for the first two quarters of 2020. Include totals...
Moriarity Company has budgeted the following unit sales: 1st Quarter 2019 7,000 2nd Quarter 2019 3,000...
Moriarity Company has budgeted the following unit sales: 1st Quarter 2019 7,000 2nd Quarter 2019 3,000 3rd Quarter 2019 4,000 Beginning finished goods for the first quarter was 1,400 units. The company's policy is to maintain an inventory of finished goods as 20% of the next quarter sales. The production budget for the SECOND quarter is __________. (no dollar signs, decimals or commas) HINT: you must calculate the first quarter in order to calculate the 2nd quarter.
Eunice Ltd. has the following budgeted sales for the next six-month period: Month Unit Sales January...
Eunice Ltd. has the following budgeted sales for the next six-month period: Month Unit Sales January 80,000 February 90,000 March 120,000 April 150,000 May 180,000 June 120,000 Eunice Ltd. sells a single product at a price of $60 per unit. There were 18,000 units of finished goods in inventory at the beginning of February. Eunice Ltd.’s policy is to keep the inventory of finished goods equal to 20% of the unit sales for the next month. Three kilograms of materials...
Troy Corporation has the following budgeted sales for the selected four-month period: Month Unit Sales October...
Troy Corporation has the following budgeted sales for the selected four-month period: Month Unit Sales October 40,000 November 70,000 December 50,000 January 60,000 There were 14,000 units of finished goods in inventory at the beginning of October. Plans are to have an inventory of finished product equal to 25 percent of the unit sales for the next month. Five pounds of a single raw material are required for each unit produced. Each pound of material costs $10. Plans are to...
Jones Corporation has the following budgeted sales for the selected four-month period: Month Unit Sales July...
Jones Corporation has the following budgeted sales for the selected four-month period: Month Unit Sales July 35,000 August 20,000 September 30,000 October 25,000 Sales price per unit is $200 Plans are to have an inventory of finished product equal to 30% of the unit sales for the next month. There was 10,500 units in beginning inventory on July 1st. Five pounds of materials are required for each unit produced. Each pound of material costs $10. Inventory levels for materials equal...
A company has the following information: Unit sales             13,400 Sales price per unit          $...
A company has the following information: Unit sales             13,400 Sales price per unit          $ 90.00 Variable costs per unit   $ 40.00 Fixed costs          $ 500,000 A. What is the company’s contribution margin per unit? B. What is the company’s total contribution margin? C. What is the company’s operating income? D. What is the company’s margin of safety in units? E. If the company had a target operating income of $636,000, what would be the target sales in...
Kristopher Company has budgeted sales of $300,000 with the following budgeted costs:       Direct materials                    &nb
Kristopher Company has budgeted sales of $300,000 with the following budgeted costs:       Direct materials                                       $60,000       Direct manufacturing labor                       40,000       Factory overhead             Variable                                               30,000             Fixed                                                    50,000       Selling and administrative expenses             Variable                                               20,000             Fixed                                                    30,000       Required (10 points):             Compute the average markup percentage for setting prices as a percentage of:                         The full cost of the product The variable cost of the product Variable manufacturing costs Total manufacturing costs
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT