Question

Golden Company manufactures burglar-resistant commercial door locks. Recently the company began selling locks on the Web,...

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
Sales Budget
For the Year Ending December 31, 2018

First
Quarter

Second
Quarter

Third
Quarter

Fourth
Quarter


Year

Projected sales

Sales price per unit

$

$

$

$

$

Budget revenue for 2018

$

$

$

$

$

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Golden Company
Sales Budget
For the Year Ending December 31, 2018

First
Quarter

Second
Quarter

Third
Quarter

Fourth
Quarter


Year

Projected sales

27000*1.19 = 32130

33000*1.19 = 39270

32000*1.19 = 38080

38000*1.19 = 45220

154700

Sales price per unit

$25

$25

$25

$25

$25

Budget revenue for 2018

$803250

$981750

$952000

$1130500

$3867500

Add a comment
Know the answer?
Add Answer to:
Golden Company manufactures burglar-resistant commercial door locks. Recently the company began selling locks on the Web,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Problem 1: Sales Budget Locksafe Company manufactures burglar-resistant commercial door locks. Recently the company began selling...

    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...

    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...

    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 i...

    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...

    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...

  • Okay Company is preparing to build its master budget. The budget will detail each quarter's activity and the activity for the year in total.

    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...

    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...

    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...

    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...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT