Golden Company manufactures burglar-resistant commercial door
locks. Recently the company began selling locks on the Web, and the
company expects sales to increase dramatically compared with the
prior year. For the past year, 2017, unit sales were:
| First quarter | $27,000 | units | |
| Second quarter | 33,000 | units | |
| Third quarter | 32,000 | units | |
| Fourth quarter | 38,000 | units |
Assume that total sales for each quarter in 2018 will be 19 percent
higher than in 2017 and that the selling price per lock is $25.
Prepare a sales budget by quarter for 2018.
|
Golden Company |
|||||
|
First |
Second |
Third |
Fourth |
|
|
|
Projected sales |
|
|
|
|
|
|
Sales price per unit |
$
|
$
|
$
|
$
|
$
|
|
Budget revenue for 2018 |
$
|
$
|
$
|
$
|
$
|
|
Golden Company |
|||||
|
First |
Second |
Third |
Fourth |
|
|
|
Projected sales |
|
|
|
38000*1.19 = 45220 |
|
|
Sales price per unit |
$25
|
$25
|
$25
|
$25
|
$25
|
|
Budget revenue for 2018 |
$803250
|
$981750
|
$952000
|
$1130500
|
$3867500
|
Golden Company manufactures burglar-resistant commercial door locks. Recently the company began selling locks on the Web,...
Problem 1: Sales Budget Locksafe Company manufactures burglar-resistant commercial door locks. Recently the company began selling locks on the Web, and the company expects sales to increase dramatically compared with the prior year. For the past year, 2017, unit sales were: First quarter 23,000 units Second quarter 28,000 units Third quarter 27,000 units Fourth quarter 32,000 units Assume that total unit sales for each quarter in 2018 will be 30 percent higher than in 2017 and that the selling price...
Beca Adventures provides tours of scenic locations in Oregon. The company expects tours taken to increase dramatically compared with the prior year. For the past year, 2017, the number of tours given were as follows: First quarter 8,000 Second quarter 10,000 Third quarter 10,000 Fourth quarter 12,000 Assume that sales for each quarter in 2018 will be 26 percent higher than in 2017 and that the price per tour is $86. Prepare a sales budget by quarter for 2018.
Electro Company manufactures an innovative automobile
transmission for electric cars. Management predicts that ending
finished goods inventory for the first quarter will be 277,800
units. The following unit sales of the transmissions are expected
during the rest of the year: second quarter, 463,000 units; third
quarter, 317,000 units; and fourth quarter, 499,000 units. Company
policy calls for the ending finished goods inventory of a quarter
to equal 60% of the next quarter's budgeted sales.
Prepare a production budget for both...
The company’s variable selling and administrative expense per
unit is $3.30. Fixed selling and administrative expenses include
advertising expenses of $11,000 per quarter, executive salaries of
$53,000 per quarter, and depreciation of $33,000 per quarter. In
addition, the company will make insurance payments of $4,000 in the
first quarter and $4,000 in the third quarter. Finally, property
taxes of $7,200 will be paid in the second quarter.
Required:
Prepare the company’s selling and administrative expense budget
for the upcoming...
Hectro Company manufactures an Innovative automobile transmission for electric cars. Management predicts that ending finished goods Inventory for the first quarter will be 50,000 units. The following unit sales of the transmissions are expected during the rest of the year: second quarter, 500,000 units, third quarter, 454,000 units, and fourth quarter, 366,500 units. Company policy calls for the ending finished goods Inventory of a quarter to equal 10% of the next quarter's budgeted sales. Prepare a production budget for both...
Master Budget ProjectOkay Company is preparing to build its master budget. The budget will detail each quarter's activity and the activity for the year in total. The master budget will be based on the following information:a. This will be the first year of operation for Okay Company.b. Budgeted unit sales by quarter for 2017 are projected as follows: First quarter 6,300 , Second quarter 6,100 , Third quarter 6,100 & Fourth quarter 6,450 . First and second quarter 2018 budgeted...
Electro Company manufactures an innovative automobile transmission for electric cars. Management predicts that ending finished goods inventory for the first quarter will be 157,000 units. The following unit sales of the transmissions are expected during the rest of the year second quarter, 314,000 units, third quarter, 292,000 units and fourth quarter, 497,000 units. Company policy calls for the ending finished goods inventory of a quarter to equal 50% of the next quarter's budgeted sales. Prepare a production budget for both...
Electro Company manufactures an innovative automobile transmission for electric cars. Management predicts that ending finished goods inventory for the first quarter will be 83,400 units. The following unit sales of the transmissions are expected during the rest of the year: second quarter, 417,000 units; third quarter, 476,000 units; and fourth quarter, 276,500 units. Company policy calls for the ending finished goods inventory of a quarter to equal 20% of the next quarter's budgeted sales. Prepare a production budget for both...
Electro Company manufactures an innovative automobile transmission for electric cars. Management predicts that ending finished goods inventory for the first quarter will be 132,000 units. The following unit sales of the transmissions are expected during the rest of the year: second quarter, 220,000 units; third quarter, 318,000 units, and fourth quarter, 243,000 units. Company policy calls for the ending finished goods inventory of a quarter to equal 60% of the next quarter's budgeted sales. Prepare a production budget for both...
Electro Company manufactures an innovative automobile transmission for electric cars. Management predicts that ending finished goods inventory for the first quarter will be 170.500 units. The following unit sales of the transmissions are expected during the rest of the year: second quarter, 341,000 units; third quarter, 219,000 units, and fourth quarter, 266,000 units. Company policy calls for the ending finished goods inventory of a quarter to equal 50% of the next quarter's budgeted sales. Prepare a production budget for both...