Question

In: Accounting

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 had the following production budget:

1st Quarter 2019 8.000 units
2nd Quarter 2019 9,000 units

Each unit requires 4 pounds of raw materials at $2 per pound. JTS wants a raw materials inventory of 40% of the next months raw materials (the same percentage was used in 2018). The raw materials budget for the first quarter of 2019 is _______________. (no dollar signs, commas or decimals)

C) Shadwell Company has budgeted the following unit sales:

1st Quarter 2019                        10.000 units
2nd Quarter 2019                       7,000 units

It also had the following production budget:

1st Quarter 2019 12,000 units
2nd Quarter 2019 8,000 units

Each unit requires 6 pounds of raw materials at $3 per pound. Each unit requires 1.5 hours of direct labor at $20 per hour. Manufacturing overhead is 60% of direct labor cost.

Cost of goods sold for Shadwell Company for the 2nd quarter is ____________. (no dollar signs, commas nor decimals).

Solutions

Expert Solution

Ans. A Moriarity Company
Production Budget
First quarter Second quarter
Sales 7,000 3,000
Add: Desired Ending inventory 600 800
Total needs 7,600 3,800
Less: Beginning inventory -1400 -600
Units to be produced 6,200 3,200
*Calculations for Ending inventory: *Calculations for Beginning inventory:
Quarter Quarter
1 3,000 * 20% 600 1 Given 1400
2 4,000 * 20% 800 2 Ending inventory of Q1 600
Ans.   B JTS Corp.
Direct Materials Budget
First quarter
Budgeted production (units) 8,000
(X) Materials requirement per unit 4
Materials needed for production 32000
Add: budgeted ending inventory 14400
Total materials requirements 46400
Less: Budgeted beginning inventory -12800
Materials to be purchased 33600
(X) Direct materials per unit $2
Total budgeted direct materials $67,200
*Calculations for materials needed for second quarter :
Second Quarter
Budgeted production (units) 9,000
(X) Materials requirement per unit 4
Materials needed for production 36000
*Ending inventory for current quarter = Materials requirements of 2nd quarter * 40%
36,000 * 40%    =   14,400
Quarter 1 beginning inventory = Ending inventory of quarter 4 of 2018 = 40% of first quarter of 2019 Materials needed for prodution
32,000 * 40%    
12800
Ans. C Particulars Amount
Direct materials $126,000
Direct labor $210,000
Manufacturing overhead $126,000
Cost of goods sold $462,000
*Calculations for direct materials:
Second Quarter
Budgeted production (units) 7,000
(X) Materials requirement per unit 6
Materials to be purchased 42000

Related Solutions

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.
Ring The Bells Co. makes one product. Budgeted unit sales for 1st Quarter, 2nd Quarter, 3rd...
Ring The Bells Co. makes one product. Budgeted unit sales for 1st Quarter, 2nd Quarter, 3rd Quarter, and 4th Quarter are 580,000; 560,000; 575,000; and 590,000 units, respectively. The ending finished goods inventory should equal 5% of the following month's sales. The budgeted required production for 3rd Quarter is: a. 575,000 units b. 575,750 units c. 574,250 units d. 560,750 units e. 560,000 units
Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: 1st Quarter 2nd...
Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 35,000 37,000 28,000 33,000 The company’s variable selling and administrative expense per unit is $3.40. Fixed selling and administrative expenses include advertising expenses of $12,000 per quarter, executive salaries of $53,000 per quarter, and depreciation of $34,000 per quarter. In addition, the company will make insurance payments of $5,000 in the first quarter and $5,000 in...
Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: 1st Quarter 2nd...
Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 21,000 28,000 19,000 19,000 The company’s variable selling and administrative expense per unit is $2.00. Fixed selling and administrative expenses include advertising expenses of $14,000 per quarter, executive salaries of $41,000 per quarter, and depreciation of $20,000 per quarter. In addition, the company will make insurance payments of $5,000 in the first quarter and $5,000 in...
Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: 1st Quarter 2nd...
Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 31,000 33,000 24,000 29,000 The company’s variable selling and administrative expense per unit is $3.00. Fixed selling and administrative expenses include advertising expenses of $8,000 per quarter, executive salaries of $50,000 per quarter, and depreciation of $30,000 per quarter. In addition, the company will make insurance payments of $5,000 in the first quarter and $5,000 in...
Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: 1st Quarter 2nd...
Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 16,000 18,000 15,000 14,000 The company’s variable selling and administrative expense per unit is $1.50. Fixed selling and administrative expenses include advertising expenses of $9,000 per quarter, executive salaries of $35,000 per quarter, and depreciation of $15,000 per quarter. In addition, the company will make insurance payments of $4,000 in the first quarter and $4,000 in...
Mercedes, Co. has the following quarterly financial information. 4th Quarter 3rd Quarter 2nd Quarter 1st Quarter...
Mercedes, Co. has the following quarterly financial information. 4th Quarter 3rd Quarter 2nd Quarter 1st Quarter Sales Revenue $ 925,800 $ 935,300 $ 933,600 $ 941,400 Cost of Goods Sold 305,700 318,300 317,900 323,100 Operating Expenses 248,900 260,300 258,500 262,600 Interest Expense 4,200 4,200 4,200 4,100 Income Tax Expense 85,500 88,400 88,400 90,900 Average Number of Common Shares Outstanding 799,030 794,064 795,670 809,000 Stock price when Q4 EPS released $ 24 Required: Calculate the gross profit percentage for each quarter....
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...
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...
The budgeted unit sales of Weller Company for the upcoming fiscal year are provided below: 1st...
The budgeted unit sales of Weller Company for the upcoming fiscal year are provided below: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter   Budgeted unit sales 24,000 25,000 21,000 22,000 The company’s variable selling and administrative expense per unit is $2.30. Fixed selling and administrative expenses include advertising expenses of $9,000 per quarter, executive salaries of $44,000 per quarter, and depreciation of $23,000 per quarter. In addition, the company will make insurance payments of $4,000 in the first quarter and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT