Question
In: Accounting
ABC Company prepares monthly operating and financial budgets. Estimates of sales in units are made for...
ABC Company prepares monthly operating and financial budgets. Estimates of sales in units are made for each month. Production is scheduled at a level high enough to take care of current needs and to carry into each month one-half (1/2) of the next month’s unit sales. Direct materials, direct labour, and variable manufacturing overhead are estimated at $12, $6, and $4 per unit, respectively. Total fixed manufacturing overhead is budgeted at $480,000 per month. Sales for April, May, June, and July 2009 are estimated at 100,000, 120,000, 160,000, and 120,000 units. The inventory at 2019 April 1, consists of 50,000 units with a cost of $28.80 per unit.
Prepare a schedule showing the budgeted production in units for April, May, and June 2019.
Solutions
Expert Solution
| April | May | June | July | |
| Sales unit | 100,000 | 120,000 | 160,000 | 120,000 |
| Ending inventory of finished goods | 120,000x 1/2 = 60,000 | 160,000 x 1/2 = 80,000 | 120,000 x 1/2 = 60,000 | |
| Total finished goods inventory needed | 160,000 | 200,000 | 220,000 | - |
| Beginning inventory of finished goods | -50,000 | -60,000 | -80,000 | |
| Production Units | 110,000 | 140,000 | 140,000 |
Ending inventory of March = sales of April x 1/2
= 100,000 x 1/2
= 50,000 units
Ending inventory of March will be the beginning inventory of April.
Kindly give a positive rating if you are satisfied with this solution and please ask if you have any query.
Thanks
ekkarill92 answered 2 years agoRelated Solutions
Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are: January February Sales...
Company prepares monthly cash budgets. Relevant data from
operating budgets for 2017 are:
January February
Sales $350,000 $400,000
Direct materials purchases 120,000 110,000
Direct labor 85,000 112,000
Manufacturing overhead 60,000 75,000
Selling and administrative expenses 75,000 80,000
All sales are on account. Collections are expected to be 50%
in the month of sale, 40% in the first month following the sale,
and 10% in the second month following the sale. Thirty percent
(30%) of direct materials purchases are paid in...
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows....
Colter Company prepares monthly cash budgets. Relevant data from
operating budgets for 2020 are as follows.
January
February
Sales
$439,200
$488,000
Direct materials purchases
146,400
152,500
Direct labor
109,800
122,000
Manufacturing overhead
85,400
91,500
Selling and administrative
expenses
96,380
103,700
All sales are on account. Collections are expected to be 50% in the
month of sale, 30% in the first month following the sale, and 20%
in the second month following the sale. Sixty percent (60%) of
direct materials purchases...
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows:...
Colter Company prepares monthly cash budgets. Relevant data from
operating budgets for 2017 are as follows:
January
February
Sales
$ 426,960
$ 474,400
Direct materials purchases
142,320
148,250
Direct labor
106,740
118,600
Manufacturing overhead
83,020
88,950
Selling and administrative expenses
93,694
100,810
All sales are on account. Collections are expected to be 50% in the
month of sale, 30% in the first month following the sale, and 20%
in the second month following the sale. Sixty percent (60%) of
direct...
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows....
Colter Company prepares monthly cash budgets. Relevant data from
operating budgets for 2020 are as follows.
January
February
Sales
$435,600
$484,000
Direct materials purchases
145,200
151,250
Direct labor
108,900
121,000
Manufacturing overhead
84,700
90,750
Selling and administrative expenses
95,590
102,850
All sales are on account. Collections are expected to be 50% in the
month of sale, 30% in the first month following the sale, and 20%
in the second month following the sale. Sixty percent (60%) of
direct materials purchases...
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows:...
Colter Company prepares monthly cash budgets. Relevant data from
operating budgets for 2017 are as follows:
January
February
Sales
$ 425,520
$ 472,800
Direct materials purchases
141,840
147,750
Direct labor
106,380
118,200
Manufacturing overhead
82,740
88,650
Selling and administrative expenses
93,378
100,470
All sales are on account. Collections are expected to be 50% in the
month of sale, 30% in the first month following the sale, and 20%
in the second month following the sale. Sixty percent (60%) of
direct...
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows....
Colter Company prepares monthly cash budgets. Relevant data from
operating budgets for 2020 are as follows.
January
February
Sales
$439,200
$488,000
Direct materials purchases
146,400
152,500
Direct labor
109,800
122,000
Manufacturing overhead
85,400
91,500
Selling and administrative
expenses
96,380
103,700
All sales are on account. Collections are expected to be 50% in the
month of sale, 30% in the first month following the sale, and 20%
in the second month following the sale. Sixty percent (60%) of
direct materials purchases...
Ayayai Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows:...
Ayayai Company prepares monthly cash budgets. Relevant data from
operating budgets for 2017 are as follows:
January
February
Sales
$363,600
$404,000
Direct materials purchases
121,200
126,250
Direct labor
90,900
101,000
Manufacturing overhead
70,700
75,750
Selling and administrative expenses
79,790
85,850
All sales are on account. Collections are expected to be 50% in the
month of sale, 30% in the first month following the sale, and 20%
in the second month following the sale. Sixty percent (60%) of
direct materials purchases...
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows....
Colter Company prepares monthly cash budgets. Relevant data from
operating budgets for 2020 are as follows.
January
February
Sales
$399,600
$444,000
Direct materials
purchases
133,200
138,750
Direct labor
99,900
111,000
Manufacturing
overhead
77,700
83,250
Selling and
administrative expenses
87,690
94,350
All sales are on account. Collections are expected to be 50% in the
month of sale, 30% in the first month following the sale, and 20%
in the second month following the sale. Sixty percent (60%) of
direct materials purchases...
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows:...
Colter Company prepares monthly cash budgets. Relevant data from
operating budgets for 2017 are as follows:
January
February
Sales
$425,520
$472,800
Direct materials purchases
141,840
147,750
Direct labor
106,380
118,200
Manufacturing overhead
82,740
88,650
Selling and administrative expenses
93,378
100,470
All sales are on account. Collections are expected to be 50% in the
month of sale, 30% in the first month following the sale, and 20%
in the second month following the sale. Sixty percent (60%) of
direct materials purchases...
Question 2 Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are...
Question 2
Colter Company prepares monthly cash budgets. Relevant data from
operating budgets for
2017 are as follows.
January February
Sales $360,000 $400,000
Direct materials purchases 120,000 125,000
Direct labour 90,000 100,000
Manufacturing overhead 70,000 75,000
Selling and administrative expenses 79,000 85,000
All sales are on account. Collections are expected to be 50% in the
month of sale, 30% in
the first month following the sale, and 20% in the second month
following the sale. Sixty
percent (60%) of direct...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Given an array of Student type and size 10, create a linked list of students by...
- Magnolia Manufacturing makes wing components for large aircraft. Kevin Choi is the production manager, responsible for...
- Pompeii Pizza Club owns three identical restaurants popular for their specialty pizzas. Each restaurant has a...
- INPUT FILE INTO ARRAY. CHECKING FOR COMMAS AND SUCH. HOW TO DO? void readFile(Candidate candidates[]) –...
- (C++) How do I go about obtaining the origin of a point via an instance variable?...
- Do relativism and subjectivism generate contradictions? Why might someone accuse the theories of doing so? How...
- (1) Define the term identifier as a name for something, such as a variable, constant, or...
ADVERTISEMENT