SmithSmith Foods produces specialty soup sold in jars. The projected sales in dollars and jars for...

SmithSmith

Foods produces specialty soup sold in jars. The projected sales in dollars and jars for each quarter of the upcoming year are as? follows:

	Total sales revenue		Number of jars sold
1st quarter. . . .		$181,000	153,000
2nd quarter. . . .		$213,000	180,000
3rd quarter. . . .		$257,000	212,500
4th quarter. . . .		$194,000	163,500

SmithSmith

anticipates selling

226 comma 000226,000

jars with total sales revenue of

$ 266 comma 000$266,000

in the first quarter of the year following the year given in the preceding table.

SmithSmith

has a policy that the ending inventory of jars must be

3030?%

of the following? quarter's sales.

Requirement

Prepare a production budget for the year that shows the number of jars to be produced each quarter and for the year in total.

Prepare the production budget by first calculating the total units? needed, then calculate the units to produce.

Smith Foods
Production Budget
For the Quarters in the Upcoming Year
	Quarter 1	Quarter 2	Quarter 3	Quarter 4	Year
Unit sales	153,000	180,000	212,500	163,500	709,000
Plus: Desired ending inventory	54,000	63,750	49,050	67,800	67,800
Total needed	207,000	243,750	261,550	231,300	776,800

Less: Beginning inventory	45,900	54,000	63,750	69390	233040
Units to produce	161,100	189,750	197,800

Enter any number in the edit fields and then click Check Answer.

All parts showing

Clear All

Final Check

Solutions

Expert Solution

keosha answered 3 months ago

Next > < Previous

Related Solutions

Part A Epic Foods produces specialty soup sold in mason jars. The projected sales in dollars...

Part A Epic Foods produces specialty soup sold in mason jars. The projected sales in dollars and jars for each quarter of the upcoming year are as follows: Total sales revenue Number of jars sold 1st quarter (2021) $182,000 150,000 2nd quarter(2021) $210,000 180,500 3rd quarter(2021) $251,000 213,500 4th quarter(2021) $195,000 164,500 Epic anticipates selling 223,000 jars with total sales revenue of $265,000 in the first quarter of the year (2022) following the year given in the table above. Epic...

HawthornHawthorn Foods processes bags of organic frozen fruits sold at specialty grocery store. The company allocates...

HawthornHawthorn Foods processes bags of organic frozen fruits sold at specialty grocery store. The company allocates manufacturing overhead based on direct labor hours. HawthornHawthorn has budgeted fixed manufacturing overhead for the year to be $ 629 comma 000$629,000. The predetermined fixed manufacturing overhead rate is $ 16.40$16.40 per direct laborhour, while the standard variable manufacturing overhead rate is $ 0.50$0.50 per direct labor hour. The direct labor standard for each case is one minus quarterone−quarter (0.250.25) of an hour. The...

Company produces and sells 90,000 boxes of specialty foods each year. Each box contains the same...

Company produces and sells 90,000 boxes of specialty foods each year. Each box contains the same assortment of food. The company has computed the following annual costs: Cost Item Total Costs Variable production costs $630,000 Fixed production costs 470,000 Variable selling costs 180,000 Fixed selling and administrative costs 170,000 Total costs $1,450,000 Mendenhall normally charges $ 30 per box. A new distributor has offered to purchase 9,000 boxes at a special price of $ 27 per box. Mendenhall will incur...

Peanut Land Inc. produces all-natural organic peanut butter. The peanut butter is sold in 12-ounce jars....

Peanut Land Inc. produces all-natural organic peanut butter. The peanut butter is sold in 12-ounce jars. The sales budget for the first four months of the year is as follows: Unit Sales Dollar Sales ($) January 80,000 176,000 February 45,000 99,000 March 40,000 88,000 April 42,000 92,400 Company policy requires that ending inventories for each month be 10% of next month's sales. At the beginning of January, the inventory of peanut butter is 31,000 jars. Each jar of peanut butter...

Peanut Land Inc. produces all-natural organic peanut butter. The peanut butter is sold in 12-ounce jars....

Peanut Land Inc. produces all-natural organic peanut butter. The peanut butter is sold in 12-ounce jars. The sales budget for the first four months of the year is as follows: Unit Sales Dollar Sales ($) January 70,000 147,000 February 65,000 136,500 March 60,000 126,000 April 62,000 130,200 Company policy requires that ending inventories for each month be 10% of next month's sales. At the beginning of January, the inventory of peanut butter is 31,000 jars. Each jar of peanut butter...

Company produces and sells 55 comma 00055,000 boxes of specialty foods each year. Each box contains...

Company produces and sells 55 comma 00055,000 boxes of specialty foods each year. Each box contains the same assortment of food. The company has computed the following annual costs: Cost Item Total Costs Variable production costs $330,000 Fixed production costs 520,000 Variable selling costs 165,000 Fixed selling and administrative costs 160,000 Total costs $1,175,000 GarrardGarrard normally charges $ 21$21 per box. A new distributor has offered to purchase 5 comma 5005,500 boxes at a special price of $ 17$17 per...

Figures are in millions of dollars Net sales $ 2,473.8 Cost of goods sold (COGS) $...

Figures are in millions of dollars Net sales $ 2,473.8 Cost of goods sold (COGS) $ 1,316.2 Operating expenses (S&GA) $ 575.8 Inventory $ 250.1 Accounts receivable $ 36.7 Other current assets $ 68.9 Fixed assets $ 690.0 What's the net profit margin? $____ Show work. What's the net profit margin %? _____ Show work. What's the value of total assets? $____ Show work. What's the asset turnover ? $____ Show work. What's the return on assets (ROA)? $____ Show...

What is your best estimate of the WACC for Kraft Foods, Campbell Soup Company, and Del...

What is your best estimate of the WACC for Kraft Foods, Campbell Soup Company, and Del Monte Foods? How do these WACCs influence your thinking about the WACC for Heinz?Exhibit 4 H. J. HEINZ: ESTIMATING THE COST OF CAPITAL IN UNCERTAIN TIMES Comparable Firm Data Campbell Del Kraft Soup Monte Financial Summary Revenues (in millions of dollars) 40,386 7,589 3,739 Book value of equity (in millions of dollars) 25,972 728 1,827 Book value of debt (in millions...

A. Harrison Company produces hats for golfers. The company's projected sales for April are 15,000 hats....

A. Harrison Company produces hats for golfers. The company's projected sales for April are 15,000 hats. March sales were less than expected, so the company had 1,800 hats remaining in inventory at the end of March. Harrison prefers to maintain a 5 percent inventory of the next month's sales. Expected sales for May are 14,000 hats. How many hats should the company plan to produce in April? a. 15,700 b. 15,000 c. 13,900 d. 17,500 B. Tea lovers produce herbal...

ABC Company limited produces coat racks. The projected sales for the first quarter of the coming...

ABC Company limited produces coat racks. The projected sales for the first quarter of the coming year and the beginning and ending inventory data are as follows: Sales 100,000 units Unit price SAR 15 Beginning inventory 8,000 units Targeted ending inventory 12,000 units The coat racks are molded and then painted. Each rack requires four pounds of metal, which cost SAR 2.50 per pound. The beginning inventory of materials is 4,000 pounds. ABC Company Limited wants to have 6,000 pounds...

Subjects