Production Budget and Direct Materials Purchases Budget

Raylene Webber, owner of Raylene's Flowers and Gifts, produces gift baskets for various special occasions. Each gift basket includes fruit or assorted small gifts $($e$.$g$.,$ a coffee mug, deck of cards, novelty cocoa mixes, scented soap$)$ in a basket that is wrapped in colourful cellophane. Raylene has estimated the following unit sales of the standard gift basket for the rest of the year and for January of next year.

September $250$

October $200$

November $230$

December $380$

January $100$

Raylene likes to have $5\%$ of the next month's sales needs on hand at the end of each month. This requirement was met on August $31.$

Two materials are needed for each fruit basket:

Fruit $1$ kilogram

Small gifts $6$ items

The materials inventory policy is to have $5\%$ of the next month's fruit needs on hand and $40\%$ of the next month's production needs of small gifts. $($The relatively low inventory amount for fruit is designed to prevent spoilage.$)$ Materials inventory on August $31$ met this company policy.

Required:

Question Content Area

$1.$ Prepare a production budget for September, October, November, and December for gift baskets. $($Note: Round all answers to the nearest whole unit.$)$

Raylene's Flowers and Gifts

Production Budget for Gift Baskets

For September, October, November, and December

September October November December

Sales fill in the blank $73$d$8$d$6$f$11$f$8706$f$\_1$

$250$

fill in the blank $73$d$8$d$6$f$11$f$8706$f$\_2$

$200$

fill in the blank $73$d$8$d$6$f$11$f$8706$f$\_3$

$230$

fill in the blank $73$d$8$d$6$f$11$f$8706$f$\_4$

$380$

Desired ending inventory fill in the blank $73$d$8$d$6$f$11$f$8706$f$\_5$

$10$

fill in the blank $73$d$8$d$6$f$11$f$8706$f$\_6$

$12$

fill in the blank $73$d$8$d$6$f$11$f$8706$f$\_7$

$19$

fill in the blank $73$d$8$d$6$f$11$f$8706$f$\_8$

$5$

Needed fill in the blank $73$d$8$d$6$f$11$f$8706$f$\_9$

$260$

fill in the blank $73$d$8$d$6$f$11$f$8706$f$\_10$

$212$

fill in the blank $73$d$8$d$6$f$11$f$8706$f$\_11$

$249$

fill in the blank $73$d$8$d$6$f$11$f$8706$f$\_12$

$385$

Less: Beginning inventory production fill in the blank $73$d$8$d$6$f$11$f$8706$f$\_13$

$13$

fill in the blank $73$d$8$d$6$f$11$f$8706$f$\_14$

$10$

fill in the blank $73$d$8$d$6$f$11$f$8706$f$\_15$

$12$

fill in the blank $73$d$8$d$6$f$11$f$8706$f$\_16$

$19$

Total fill in the blank $73$d$8$d$6$f$11$f$8706$f$\_17$

$247$

fill in the blank $73$d$8$d$6$f$11$f$8706$f$\_18$

$202$

fill in the blank $73$d$8$d$6$f$11$f$8706$f$\_19$

$238$

fill in the blank $73$d$8$d$6$f$11$f$8706$f$\_20$

$366$

Feedback Area

Feedback

$1.$ See Cornerstone $9\mathrm{.}2.$

Question Content Area

$2.$ Prepare a direct materials purchases budget for the two types of materials used in the production of gift baskets for the months of September, October, and November. $($Note: Round answers to the nearest whole unit.$)$

Raylene's Flowers and Gifts

Direct Materials Purchases Budget

For September, October, and November

Fruit: September October November

Production fill in the blank b$0$a$853033$f$9507$f$\_1$

$247$

fill in the blank b$0$a$853033$f$9507$f$\_2$

$202$

fill in the blank b$0$a$853033$f$9507$f$\_3$

$238$

Kilograms of fruit fill in the blank b$0$a$853033$f$9507$f$\_4$

$1$

fill in the blank b$0$a$853033$f$9507$f$\_5$

$1$

fill in the blank b$0$a$853033$f$9507$f$\_6$

$1$

Required for production fill in the blank b$0$a$853033$f$9507$f$\_7$

$247$

fill in the blank b$0$a$853033$f$9507$f$\_8$

$203$

fill in the blank b$0$a$853033$f$9507$f$\_9$

$238$

Desired ending inventory fill in the blank b$0$a$853033$f$9507$f$\_10$

$10$

fill in the blank b$0$a$853033$f$9507$f$\_11$

$12$

fill in the blank b$0$a$853033$f$9507$f$\_12$

$19$

Total needs fill in the blank b$0$a$853033$f$9507$f$\_13$

$257$

fill in the blank b$0$a$853033$f$9507$f$\_14$

$215$

fill in the blank b$0$a$853033$f$9507$f$\_15$

$256$

Less: Beginning inventory fill in the blank b$0$a$853033$f$9507$f$\_16$

$13$

fill in the blank b$0$a$853033$f$9507$f$\_17$

$10$

fill in the blank b$0$a$853033$f$9507$f$\_18$

$12$

Kilograms purchased fill in the blank b$0$a$853033$f$9507$f$\_19$

$244$

fill in the blank b$0$a$853033$f$9507$f$\_20$

$205$

fill in the blank b$0$a$853033$f$9507$f$\_21$

$244$

Small gifts:

Production fill in the blank b$0$a$853033$f$9507$f$\_22$

$247$

fill in the blank b$0$a$853033$f$9507$f$\_23$

$202$

fill in the blank b$0$a$853033$f$9507$f$\_24$

$238$

Items required fill in the blank b$0$a$853033$f$9507$f$\_25$

$6$

fill in the blank b$0$a$853033$f$9507$f$\_26$

$6$

fill in the blank b$0$a$853033$f$9507$f$\_27$

$6$

Needed for production fill in the blank b$0$a$853033$f$9507$f$\_28$

$1,482$

fill in the blank b$0$a$853033$f$9507$f$\_29$

$1,212$

fill in the blank b$0$a$853033$f$9507$f$\_30$

$1,422$

Desired inventory fill in the blank b$0$a$853033$f$9507$f$\_31$

$485$

fill in the blank b$0$a$853033$f$9507$f$\_32$

$569$

fill in the blank b$0$a$853033$f$9507$f$\_33$

$845$

Total needs fill in the blank b$0$a$853033$f$9507$f$\_34$

$1,967$

fill in the blank b$0$a$853033$f$9507$f$\_35$

$1,781$

fill in the blank b$0$a$853033$f$9507$f$\_36$

$2,202$

Less: Beginning inventory fill in the blank b$0$a$853033$f$9507$f$\_37$

$593$

fill in the blank b$0$a$853033$f$9507$f$\_38$

$485$

fill in the blank b$0$a$853033$f$9507$f$\_39$

$506$

Items purchased fill in the blank b$0$a$853033$f$9507$f$\_40$

$1,374$

fill in the blank b$0$a$853033$f$9507$f$\_41$

$1,296$

fill in the blank b$0$a$853033$f$9507$f$\_42$

$1,694$