Question

In: Accounting

The following information regarding for the preparation of first quarter budget, ended March 31,2020: Units to...

The following information regarding for the preparation of first quarter budget, ended March 31,2020:

  1. Units to be sold in January is 1.000 units @$200. The following month units sold increased by 25%.
  2. Ending finished goods inventory is 60% of total units sold in the next month.
  3. To produce one unit finished goods using 2 types of materials, with the following information:

Material A      2 kgs @ $25

Material B      3 kgs @$28

  1. Production needs 3 hours of labor at $22. And ending direct materials is 70% of production.
  2. Overhead cost 3 hours per unit at $5 variable overhead costs and fixed overhead is 80% of variable overhead costs.
  3. Operating expenses 22% of sales value each month.

Instructions:

  1. Prepare a sales, production, purchase, direct labor, FOH, operating expenses budget for first quarter 2020.
  2. Why do we always prepare production budget instead of purchasing budget? Explain.

Solutions

Expert Solution


Related Solutions

   . Prepare a cash budget for January through March and for the first quarter in...
   . Prepare a cash budget for January through March and for the first quarter in total. The company maintains a minimum cash balance of $70,000, and this was the balance in the cash account on January 1st. Other expenses include $35,000 per month for rent, $24,000 per month for advertising, and $66,000 per month for depreciation. In addition, variable Selling & Administrative cost is $12 per unit sold, and the company paid a $20,000 dividend in February. The company...
“Diamond Company” is preparing a budget for the first quarter of year 2020. The following information...
“Diamond Company” is preparing a budget for the first quarter of year 2020. The following information is available: Total expected sales for last two months of 2019 and four months of 2020 are (in 000’s LE) November December January February March April Sales 200 200 160 160 180 180 All sales are on credit and collections from sales are 60% in the month of sales, 30% in the next month, and 10% in the following month. Cost of goods sold...
“Diamond Company” is preparing a budget for the first quarter of year 2020. The following information...
“Diamond Company” is preparing a budget for the first quarter of year 2020. The following information is available: Total expected sales for last two months of 2019 and four months of 2020 are (in 000’s LE) November December January February March April Sales 200 200 160 160 180 150 All sales are on credit and collections from sales are 60% in the month of sales, 30% in the next month, and 10% in the following month. Cost of goods sold...
Prepare a sales budget for the first quarter (Q1) and the first quarter in total. The...
Prepare a sales budget for the first quarter (Q1) and the first quarter in total. The selling price per unit is $50.00. December 50,000/ January 70,000/February 100,000 /March 60,000 / April 100,000 Past experience shows that 45% of sales are collected in the month of the sale, and 55% in the month following the sale. 2. Prepare a purchases budget for January through March, and the first quarter in total. Assume that the company only sells one product that can...
Prepare a sales budget for the first quarter (Q1) and the first quarter in total. The...
Prepare a sales budget for the first quarter (Q1) and the first quarter in total. The selling price per unit is $50.00. December of the previous year    10,000 January                                     70,000 February                                    30,000 March                                        50,000 April                                          80,000 Past experience shows that 45% of sales are collected in the month of the sale, and 55% in the month following the sale.                           2. Prepare a purchases budget for January through March, and the first quarter in total. Assume that the company only...
Sosa Company has provided the following budget information for the first quarter of 2016 Total sales...
Sosa Company has provided the following budget information for the first quarter of 2016 Total sales $297,500 Budgeted purchases of direct materials 39,450 Budgeted direct labor cost 38,880 Budgeted manufacturing overhead costs: Variable manufacturing overhead 3,645 Depreciation 600 Insurance and property taxes 9,120 Budgeted selling and administrative expenses: Salaries expense 5,000 Rent expense 3,000 Insurance expense 1,200 Depreciation expense 100 Supplies expense 2,975 Additional data related to the first quarter of 2016 for Sosa Company: a. Capital expenditures include $36,000...
Tempo Company's fixed budget (based on sales of 18,000 units) for the first quarter reveals the...
Tempo Company's fixed budget (based on sales of 18,000 units) for the first quarter reveals the following. Fixed Budget Sales (18,000 units × $208 per unit) $ 3,744,000 Cost of goods sold Direct materials $ 414,000 Direct labor 756,000 Production supplies 468,000 Plant manager salary 214,000 1,852,000 Gross profit 1,892,000 Selling expenses Sales commissions 126,000 Packaging 270,000 Advertising 100,000 496,000 Administrative expenses Administrative salaries 264,000 Depreciation—office equip. 234,000 Insurance 204,000 Office rent 214,000 916,000 Income from operations $ 480,000 (1)...
Tempo Company's fixed budget (based on sales of 10,000 units) for the first quarter reveals the...
Tempo Company's fixed budget (based on sales of 10,000 units) for the first quarter reveals the following. Fixed Budget Sales (10,000 units × $201 per unit) $ 2,010,000 Cost of goods sold Direct materials $ 230,000 Direct labor 430,000 Production supplies 260,000 Plant manager salary 30,000 950,000 Gross profit 1,060,000 Selling expenses Sales commissions 90,000 Packaging 140,000 Advertising 100,000 330,000 Administrative expenses Administrative salaries 80,000 Depreciation—office equip. 50,000 Insurance 20,000 Office rent 30,000 180,000 Income from operations $ 550,000 (1)...
Tempo Company's fixed budget (based on sales of 16,000 units) for the first quarter reveals the...
Tempo Company's fixed budget (based on sales of 16,000 units) for the first quarter reveals the following. Fixed Budget Sales (16,000 units × $209 per unit) $ 3,344,000 Cost of goods sold Direct materials $ 400,000 Direct labor 688,000 Production supplies 448,000 Plant manager salary 200,000 1,736,000 Gross profit 1,608,000 Selling expenses Sales commissions 128,000 Packaging 240,000 Advertising 100,000 468,000 Administrative expenses Administrative salaries 250,000 Depreciation—office equip. 220,000 Insurance 190,000 Office rent 200,000 860,000 Income from operations $ 280,000 (1)...
Tempo Company's fixed budget (based on sales of 10,000 units) for the first quarter reveals the...
Tempo Company's fixed budget (based on sales of 10,000 units) for the first quarter reveals the following. Fixed Budget Sales (10,000 units × $204 per unit) $ 2,040,000 Cost of goods sold Direct materials $ 230,000 Direct labor 430,000 Production supplies 270,000 Plant manager salary 30,000 960,000 Gross profit 1,080,000 Selling expenses Sales commissions 80,000 Packaging 140,000 Advertising 100,000 320,000 Administrative expenses Administrative salaries 80,000 Depreciation—office equip. 50,000 Insurance 20,000 Office rent 30,000 180,000 Income from operations $ 580,000 (1)...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT