Carter's BBQ Restaurant produces BBQ sauce for resale at grocery stores throughout North America. The company...
Carter's BBQ Restaurant produces BBQ sauce for resale at grocery stores throughout North America. The company is currently in the process of establishing a master budget on a quarterly basis for this coming fiscal year, which ends December 31. Prior year quarterly sales were as follows (1 unit = 1 batch):
|
First quarter |
67,200 units |
|
Second quarter |
80,640 units |
|
Third quarter |
100,800 units |
|
Fourth quarter |
87,360 units |
Unit sales are expected to increase by 25%, and each unit is expected to sell for $8. The management prefers to maintain ending finished goods inventory equal to 10% of next quarter's sales. Assume that finished goods inventory at the end of the fourth quarter budget period is estimated to be 9,000 units.
- Using Excel prepare a sales budget for Carter's BBQ Restaurant (Hint: Be sure to increase last year's unit sales by 25%.)
- Using Excel prepare a production budget for Carter's BBQ Restaurant
Homework Answers
Add Answer to:
Carter's BBQ Restaurant produces BBQ sauce for resale at grocery
stores throughout North America. The company...
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...
2. Using the information in Problem 9-46 (given below) construct an Excel spreadsheet to create a...
2. Using the information in Problem 9-46 (given below) construct an Excel spreadsheet to create a sales budget and a production budget. Use the format from your textbook, page 423 and figures 9-3 and 9-4. (20 Points) 9-46. Creating a Sales Budget and Production Budget Using Excel. Review the information for Kitchen Products, Inc., in Exercise 33. Prepare an Excel spreadsheet similar to Figure 9.3 and Figure 9.4 showing Kitchen Product's sales budget and production budget 9-33 Sales and Production...
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...
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 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...
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...
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...
DUE SOON, PLEASE HELP!!!! Sales for the final quarter of the prior year total 800 units....
DUE SOON, PLEASE HELP!!!!
Sales for the final quarter of the prior year total 800 units. Expected sales in units) for the current year are: 720 (Quarter 1), 480 (Quarter 2), 640 (Quarter 3), and 640 (Quarter 4). Sales for the first quarter of the following year total 960 units. The selling price is $660 per unit in the first three quarters of the year, and $690 per unit in the final quarter. Company policy calls for a given quarter's...
Check my work Electro Company manufactures an innovative automobile transmission for electric cars. Management predi...
Check my work Electro Company manufactures an innovative automobile transmission for electric cars. Management predicts that ending finished goods inventory for the first quarter will be 107,700 units. The following unit sales of the transmissions are expected during the rest of the year: second quarter, 359,000 units; third quarter, 255,000 units; and fourth quarter, 207,000 units. Company policy calls for the ending finished goods inventory of a quarter to equal 30 % of the next quarter's budgeted sales. Prepare a...
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...
2. Using the information in Problem 9-46 (given below) construct an Excel spreadsheet to create a sales budget and a production budget. Use the format from your textbook, page 423 and figures 9-3 and 9-4. (20 Points) 9-46. Creating a Sales Budget and Production Budget Using Excel. Review the information for Kitchen Products, Inc., in Exercise 33. Prepare an Excel spreadsheet similar to Figure 9.3 and Figure 9.4 showing Kitchen Product's sales budget and production budget 9-33 Sales and Production...
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...
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 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...
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...
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...
DUE SOON, PLEASE HELP!!!!
Sales for the final quarter of the prior year total 800 units. Expected sales in units) for the current year are: 720 (Quarter 1), 480 (Quarter 2), 640 (Quarter 3), and 640 (Quarter 4). Sales for the first quarter of the following year total 960 units. The selling price is $660 per unit in the first three quarters of the year, and $690 per unit in the final quarter. Company policy calls for a given quarter's...
Check my work Electro Company manufactures an innovative automobile transmission for electric cars. Management predicts that ending finished goods inventory for the first quarter will be 107,700 units. The following unit sales of the transmissions are expected during the rest of the year: second quarter, 359,000 units; third quarter, 255,000 units; and fourth quarter, 207,000 units. Company policy calls for the ending finished goods inventory of a quarter to equal 30 % of the next quarter's budgeted sales. Prepare a...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago