Question
Production Budget and Direct Materials Purchases Budget Jani Subramanian, owner of Jani's Flowers and Gifts, produces gift baskets for various special occasions. Each gift basket
Production Budget and Direct Materials Purchases Budget
Jani Subramanian, owner of Jani'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 colorful cellophane. Jani 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 |
Jani 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 pound | ||
Small gifts | 6 items |
The materials inventory policy is to have 5% of the next month's fruit needs on hand and 30% 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:
1. Prepare a production budget for September, October, November, and December for gift baskets. (Note: Round all answers to the nearest whole unit.)
September | October | November | December | |
Sales | fill in the blank 082508fe6019fb4_1 | fill in the blank 082508fe6019fb4_2 | fill in the blank 082508fe6019fb4_3 | fill in the blank 082508fe6019fb4_4 |
Desired ending inventory | fill in the blank 082508fe6019fb4_5 | fill in the blank 082508fe6019fb4_6 | fill in the blank 082508fe6019fb4_7 | fill in the blank 082508fe6019fb4_8 |
Needed | fill in the blank 082508fe6019fb4_9 | fill in the blank 082508fe6019fb4_10 | fill in the blank 082508fe6019fb4_11 | fill in the blank 082508fe6019fb4_12 |
Less: Beginning inventory | fill in the blank 082508fe6019fb4_13 | fill in the blank 082508fe6019fb4_14 | fill in the blank 082508fe6019fb4_15 | fill in the blank 082508fe6019fb4_16 |
Production | fill in the blank 082508fe6019fb4_17 | fill in the blank 082508fe6019fb4_18 | fill in the blank 082508fe6019fb4_19 | fill in the blank 082508fe6019fb4_20 |
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.)
Fruit: | September | October | November |
Production | fill in the blank cf762a019fe8ff5_1 | fill in the blank cf762a019fe8ff5_2 | fill in the blank cf762a019fe8ff5_3 |
Pounds of fruit | fill in the blank cf762a019fe8ff5_4 | fill in the blank cf762a019fe8ff5_5 | fill in the blank cf762a019fe8ff5_6 |
Required for production | fill in the blank cf762a019fe8ff5_7 | fill in the blank cf762a019fe8ff5_8 | fill in the blank cf762a019fe8ff5_9 |
Desired ending inventory | fill in the blank cf762a019fe8ff5_10 | fill in the blank cf762a019fe8ff5_11 | fill in the blank cf762a019fe8ff5_12 |
Total needs | fill in the blank cf762a019fe8ff5_13 | fill in the blank cf762a019fe8ff5_14 | fill in the blank cf762a019fe8ff5_15 |
Less: Beginning inventory | fill in the blank cf762a019fe8ff5_16 | fill in the blank cf762a019fe8ff5_17 | fill in the blank cf762a019fe8ff5_18 |
Pounds purchased | fill in the blank cf762a019fe8ff5_19 | fill in the blank cf762a019fe8ff5_20 | fill in the blank cf762a019fe8ff5_21 |
Small gifts: | |||
Production | fill in the blank cf762a019fe8ff5_22 | fill in the blank cf762a019fe8ff5_23 | fill in the blank cf762a019fe8ff5_24 |
Items required | fill in the blank cf762a019fe8ff5_25 | fill in the blank cf762a019fe8ff5_26 | fill in the blank cf762a019fe8ff5_27 |
Needed for production | fill in the blank cf762a019fe8ff5_28 | fill in the blank cf762a019fe8ff5_29 | fill in the blank cf762a019fe8ff5_30 |
Desired inventory | fill in the blank cf762a019fe8ff5_31 | fill in the blank cf762a019fe8ff5_32 | fill in the blank cf762a019fe8ff5_33 |
Total needs | fill in the blank cf762a019fe8ff5_34 | fill in the blank cf762a019fe8ff5_35 | fill in the blank cf762a019fe8ff5_36 |
Less: Beginning inventory | fill in the blank cf762a019fe8ff5_37 | fill in the blank cf762a019fe8ff5_38 | fill in the blank cf762a019fe8ff5_39 |
Items purchased | fill in the blank cf762a019fe8ff5_40 | fill in the blank cf762a019fe8ff5_41 | fill in the blank cf762a019fe8ff5_42 |
3. Why do you think there is such a big difference in budgeted units from November to December? Why did Jani budget fewer units in January than in December?
- December includes the holiday season and is a time when many gifts are given, January is a month of fewer gift giving occasions.
- December is the last month of the year so Jani has too budget all the balance units in her Annual budget to meet her targets.
- None of the above.
123
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started