Question

In: Accounting

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
1^st quarter (2021)	$182,000	150,000
2^nd quarter(2021)	$210,000	180,500
3^rd quarter(2021)	$251,000	213,500
4^th 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 has a policy that the ending inventory of jars must be 30% of the following quarter’s sales. Prepare a production budget for the year that shows the number of jars to be produced each quarter and the year in total.

PART B

Gable industries manufactures a popular interactive stuffed animal for children that requires two computer chips inside each toy. Gable pays $3 for each computer chip. To help guard against stockouts of the computer chip Gable has a policy that states that the ending inventory of computer chips should be at least 20% of the following month’s production needs. The production schedule for the first four months of the year is as follows:

Month	Stuffed animals to be produced
January	5,700
February	4,600
March	4,300
April	4,900

Required: Prepare a direct materials budget for the first quarter that shows both the number of computer chips needed and the dollar amount of the purchases in the budget

Solutions

Expert Solution

PRODUCTION BUDGET

PARTICULARS Q1 Q2 Q3 Q4

SALES UNIT 1,50,000 1,80,500 2,13,500 1,64,500

DESIRED CLOSING STOCK 54,150 64,050 49,350 66,900

(SEE WORKING NOTE)

TOTAL REQUIRED UNITS 204150 244550 262850 231400

LESS: OPENING

INVENTORY ( 0 ) ( 54150) ( 64050 ) (49350)

TOTAL PRODUCTION UNITS 204150 190400 198800 182050

TOTAL UNITS IN YEAR = 775400 UNITS

WORKING NOTE

CALCULATION OF DESIRED CLOSING STOCK

QTR 1 = 30 % OF QTR 2 SALES = 30% X 180500

=54150 UNITS

QTR 2 = 30 % OF QTR 3 SALES = 30% X 213500

=64050 UNITS

QTR 3 = 30 % OF QTR 4 SALES = 30% X 164500

=49350

QTR 4 = 30% OF NEXT QTR SALES =30% X 223000

=66900

PART 2 PURCHASE BUDGET

PARTICULARS JAN FEB MAR APRIL

UNITS PRODUCED 5700 4600 4300 4900

ADD: CLOSING STOCK 920 860 980 0

(SEE WORKING NOTE )

LESS: OPENING STOCK 0 920 860 980

PURCHASE IN UNITS 6620 4540 4420 3920

NO. OF CHIPS REQUIRED

PER UNIT OF FINISHED 2 2 2 2

TOTAL CHIPS REQUIRED 13240 9080 8840 7840

RATE PER CHIP $3 $3 $3 $3

TOTAL AMOUNT $39720 $27240 $26520 $23520

WORKING NOTE

CALCULATION OF DESIRED CLOSING STOCK

JAN = 20 % OF FEB SALES = 20% X 4600

=920 UNITS

FEB = 20% OF MAR SALES = 20% X 4300

=860 UNITS

MAR = 20 % OF FEB SALES = 20% X 4900

=980 UNITS

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

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

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

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

Part 1 Bainbridge, Inc. has projected sales and production in units for the second quarter of...

Part 1 Bainbridge, Inc. has projected sales and production in units for the second quarter of the coming year as follows: August September October Production 95,000 85,000 70,000 Sales 85,000 75,000 95,000 Cash-related production costs are budgeted at $12 per unit produced. Of these production costs, 35% are paid in the month in which they are incurred and the balance in the following month. Selling and administrative expenses will amount to $125,000 per month and increase 2% each month thereafter....

Subjects