50.1K

Verified Solution

Link Copied!

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,000168,000$

February $50,000105,000$

March $40,00084,000$

April $42,00088,200$

Company policy requires that ending inventories for each month be $20\%$ of next month's sales. At the beginning of January, the inventory of peanut butter is $34,000$ jars.

Each jar of peanut butter needs two raw materials: $24$ ounces of peanuts and one jar. Company policy requires that ending inventories of raw materials for each month be $20\%$ of the next month's production needs. That policy was met on January $1.$

Required:

Question Content Area

$1.$ Prepare a production budget for the first quarter of the year. Show the number of jars that should be produced each month as well as for the quarter in total.

Peanut Land Inc.

Production Budget

For the First Quarter of the Year

January February March Total

Sales fill in the blank $37112$e$04$d$031070\_1$

$80,000$

fill in the blank $37112$e$04$d$031070\_2$

$50,000$

fill in the blank $37112$e$04$d$031070\_3$

$40,000$

fill in the blank $37112$e$04$d$031070\_4$

$170,000$

Desired ending inventory fill in the blank $37112$e$04$d$031070\_5$

$10,000$

fill in the blank $37112$e$04$d$031070\_6$

$8,000$

fill in the blank $37112$e$04$d$031070\_7$

$8,400$

fill in the blank $37112$e$04$d$031070\_8$

$34,000$

Total needs fill in the blank $37112$e$04$d$031070\_9$

$90,000$

fill in the blank $37112$e$04$d$031070\_10$

$58,000$

fill in the blank $37112$e$04$d$031070\_11$

$48,400$

fill in the blank $37112$e$04$d$031070\_12$

Less: Beginning inventory fill in the blank $37112$e$04$d$031070\_13$

$34,000$

fill in the blank $37112$e$04$d$031070\_14$

fill in the blank $37112$e$04$d$031070\_15$

fill in the blank $37112$e$04$d$031070\_16$

Units produced fill in the blank $37112$e$04$d$031070\_17$

fill in the blank $37112$e$04$d$031070\_18$

fill in the blank $37112$e$04$d$031070\_19$

$2.$ Prepare a direct materials purchases budget for jars for the months of January and February.

Peanut Land Inc.

Direct Materials Purchases Budget for Jars

For January and February

January February Total

Production fill in the blank $73$ab$6$ff$46000$fe$7\_1$

fill in the blank $73$ab$6$ff$46000$fe$7\_2$

fill in the blank $73$ab$6$ff$46000$fe$7\_3$

Jar fill in the blank $73$ab$6$ff$46000$fe$7\_4$

fill in the blank $73$ab$6$ff$46000$fe$7\_5$

fill in the blank $73$ab$6$ff$46000$fe$7\_6$

Jars for production fill in the blank $73$ab$6$ff$46000$fe$7\_7$

fill in the blank $73$ab$6$ff$46000$fe$7\_8$

fill in the blank $73$ab$6$ff$46000$fe$7\_9$

Desired ending inventory fill in the blank $73$ab$6$ff$46000$fe$7\_10$

fill in the blank $73$ab$6$ff$46000$fe$7\_11$

fill in the blank $73$ab$6$ff$46000$fe$7\_12$

Total needs fill in the blank $73$ab$6$ff$46000$fe$7\_13$

fill in the blank $73$ab$6$ff$46000$fe$7\_14$

fill in the blank $73$ab$6$ff$46000$fe$7\_15$

Less: Beginning inventory fill in the blank $73$ab$6$ff$46000$fe$7\_16$

fill in the blank $73$ab$6$ff$46000$fe$7\_17$

fill in the blank $73$ab$6$ff$46000$fe$7\_18$

Jars purchased fill in the blank $73$ab$6$ff$46000$fe$7\_19$

fill in the blank $73$ab$6$ff$46000$fe$7\_20$

fill in the blank $73$ab$6$ff$46000$fe$7\_21$

Prepare a direct materials purchases budget for peanuts for the months of January and February.

Peanut Land Inc.

Direct Materials Purchases Budget for Peanuts

For January and February

January February Total

Production fill in the blank $8$b$4$a$060$b$6$fdbf$92\_1$

fill in the blank $8$b$4$a$060$b$6$fdbf$92\_2$

fill in the blank $8$b$4$a$060$b$6$fdbf$92\_3$

Ounces fill in the blank $8$b$4$a$060$b$6$fdbf$92\_4$

fill in the blank $8$b$4$a$060$b$6$fdbf$92\_5$

fill in the blank $8$b$4$a$060$b$6$fdbf$92\_6$

Ounces for production fill in the blank $8$b$4$a$060$b$6$fdbf$92\_7$

fill in the blank $8$b$4$a$060$b$6$fdbf$92\_8$

fill in the blank $8$b$4$a$060$b$6$fdbf$92\_9$

Desired ending inventory fill in the blank $8$b$4$a$060$b$6$fdbf$92\_10$

fill in the blank $8$b$4$a$060$b$6$fdbf$92\_11$

fill in the blank $8$b$4$a$060$b$6$fdbf$92\_12$

Total needs fill in the blank $8$b$4$a$060$b$6$fdbf$92\_13$

fill in the blank $8$b$4$a$060$b$6$fdbf$92\_14$

fill in the blank $8$b$4$a$060$b$6$fdbf$92\_15$

Less: Beginning inventory fill in the blank $8$b$4$a$060$b$6$fdbf$92\_16$

fill in the blank $8$b$4$a$060$b$6$fdbf$92\_17$

fill in the blank $8$b$4$a$060$b$6$fdbf$92\_18$

Ounces purchased fill in the blank $8$b$4$a$060$b$6$fdbf$92\_19$

fill in the blank $8$b$4$a$060$b$6$fdbf$92\_20$

fill in the blank $8$b$4$a$060$b$6$fdbf$92\_21$

Answer & Explanation Solved by verified expert

See Answer