Question

In: Accounting

unit sales will be 10,000 in quarter 1; 12,000 in quarter 2; 14,000 in quarter 3;...

unit sales will be 10,000 in quarter 1; 12,000 in quarter 2; 14,000 in quarter 3; and 18,000 in quarter 4. Management desires to have an ending finished goods inventory equal to 10% of the next quarter's expected unit sales. What is budgeted production in units for quarter 2?

Solutions

Expert Solution

If it is helpful, please rate the answer and if any doubt arises let me know

Budgeted Production in units for second Quarter                    12,200 units
Workings:
Second Quarter
Sales in units                    12,000
Add: Ending finished goods inventory (Sales of Next Quarter X 10%) (14000 X 10%)                      1,400
Less: Beginning finished goods (ending units of previous Quarter) (12000 X 10%)                      1,200
Budgeted Production in units                    12,200

Related Solutions

  Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2   Budgeted unit sales...
  Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2   Budgeted unit sales 50,000 65,000 115,000 70,000 80,000 90,000   Selling price per unit $7 per unit             1 Chapter 7: Applying Excel 2 3 Data Year 2 Quarter Year 3 Quarter 4 1 2 3 4 1 2 5 Budgeted unit sales 50,000 65,000 115,000 70,000 80,000 90,000 6 7 � Selling price per unit $8 per unit 8 � Accounts receivable, beginning balance...
An capital investment project provides a company with expected cash flows of $10,000; $12,000; $14,000; $16,000,...
An capital investment project provides a company with expected cash flows of $10,000; $12,000; $14,000; $16,000, and $18,000 in years 1-5, respectively. The investment will require an initial expenditure of $45,000 and the company has a weighted average cost of capital of 8.0%. What is the net present value of the project? What is the internal rate of return for the project given? A stock earns a monthly return of 0.85%. What is the equivalent annualized rate of return? The...
The TS Corporation has budgeted sales for the year as follows: Quarter 1 2 3 4  Sales...
The TS Corporation has budgeted sales for the year as follows: Quarter 1 2 3 4  Sales 10,000 12,000 14,000 16,000The ending inventory of finished goods for each quarter should equal 25% of the next quarter's budgeted sales in units. Four pounds of raw materials are required for each unit produced. Raw materials on hand at the start of the year total 4,200 pounds. The raw materials inventory at the end of each quarter should equal 10% of the next quarter's...
1. Tempo Company's fixed budget (based on sales of 12,000 units) for the first quarter reveals...
1. Tempo Company's fixed budget (based on sales of 12,000 units) for the first quarter reveals the following. Fixed Budget Sales (12,000 units × $211 per unit) $ 2,532,000 Cost of goods sold Direct materials $ 276,000 Direct labor 528,000 Production supplies 324,000 Plant manager salary 76,000 1,204,000 Gross profit 1,328,000 Selling expenses Sales commissions 96,000 Packaging 192,000 Advertising 100,000 388,000 Administrative expenses Administrative salaries 126,000 Depreciation—office equip. 96,000 Insurance 66,000 Office rent 76,000 364,000 Income from operations $ 576,000...
Year Quarter Sales 1 1 10 1 2 31 1 3 43 1 4 16 2...
Year Quarter Sales 1 1 10 1 2 31 1 3 43 1 4 16 2 1 11 2 2 33 2 3 45 2 4 17 3 1 13 3 2 34 3 3 48 3 4 19 4 1 15 4 2 37 4 3 51 4 4 21 a. Construct a time series plot. What type of pattern exists in the data? b. Use the following dummy variables to develop an estimated regression equation to account for...
ABC Company’s budgeted sales for June, July, and August are 12,000, 16,000, and 14,000 units, respectively....
ABC Company’s budgeted sales for June, July, and August are 12,000, 16,000, and 14,000 units, respectively. ABC requires 30% of the next month’s budgeted unit sales as finished goods inventory each month. Budgeted ending finished goods inventory for May is 3,600 units. Each unit that ABC Company produces uses 3 pounds of raw material. ABC requires 25% of the next month’s budgeted production as raw material inventory each month. Required: Calculate the number of pounds of raw material to be...
DyanChrome estimates its sales at 12,000 units in the first quarter with an increase by 600...
DyanChrome estimates its sales at 12,000 units in the first quarter with an increase by 600 units each quarter over the year. It desires an ending inventory of finished goods equal to 20% of the next quarter’s sales. Each unit sells for $30. Forty percent of sales are on account, with the remainder being cash sales. Credit customers pay 90% during the quarter the sale was made and the balance during the following quarter. 16. How much are budgeted cash...
Tempo Company's fixed budget (based on sales of 14,000 units) for the first quarter of calendar...
Tempo Company's fixed budget (based on sales of 14,000 units) for the first quarter of calendar year 2017 reveals the following. Fixed Budget Sales (14,000 units) $ 2,940,000 Cost of goods sold Direct materials $ 336,000 Direct labor 588,000 Production supplies 378,000 Plant manager salary 136,000 1,438,000 Gross profit 1,502,000 Selling expenses Sales commissions 112,000 Packaging 196,000 Advertising 100,000 408,000 Administrative expenses Administrative salaries 186,000 Depreciation—office equip. 156,000 Insurance 126,000 Office rent 136,000 604,000 Income from operations $ 490,000 Complete...
Tempo Company's fixed budget (based on sales of 14,000 units) for the first quarter of calendar...
Tempo Company's fixed budget (based on sales of 14,000 units) for the first quarter of calendar year 2017 reveals the following. Fixed Budget Sales (14,000 units) $ 2,954,000 Cost of goods sold Direct materials $ 350,000 Direct labor 588,000 Production supplies 378,000 Plant manager salary 150,000 1,466,000 Gross profit 1,488,000 Selling expenses Sales commissions 112,000 Packaging 224,000 Advertising 100,000 436,000 Administrative expenses Administrative salaries 200,000 Depreciation—office equip. 170,000 Insurance 140,000 Office rent 150,000 660,000 Income from operations $ 392,00 Complete...
Tempo Company's fixed budget (based on sales of 14,000 units) for the first quarter reveals the...
Tempo Company's fixed budget (based on sales of 14,000 units) for the first quarter reveals the following. Fixed Budget Sales (14,000 units × $219 per unit) $ 3,066,000 Cost of goods sold Direct materials $ 350,000 Direct labor 588,000 Production supplies 392,000 Plant manager salary 150,000 1,480,000 Gross profit 1,586,000 Selling expenses Sales commissions 98,000 Packaging 224,000 Advertising 100,000 422,000 Administrative expenses Administrative salaries 200,000 Depreciation—office equip. 170,000 Insurance 140,000 Office rent 150,000 660,000 Income from operations $ 504,000 (1)...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT