Question
Nguyen Nibbles Inc. manufactures a line of rice crackers. Nguyens management accountant has been doing a full analysis of the costs and activities. The information
Nguyen Nibbles Inc. manufactures a line of rice crackers. Nguyen’s management accountant has been doing a full analysis of the costs and activities. The information obtained from this analysis is as follows:
For the coming year (20X7), Nguyen predicts that sales of crackers will be 3,645,000 packages at $0.90 per package evenly throughout the year. The company keeps 5% of salesin finished goods inventory for the following month. Opening inventory for finished goods was 14,500 packages at a cost of $0.28 each. Nguyen uses first in, first out (FIFO) for producing the process cost report for inventory valuation. The opening inventory for direct materials is $15,200. Purchases for the year are budgeted at $304,000 with an estimated ending inventory of $15,620. Direct labour for the year is expected to be $311,500 for all production. Sales costs are 6% of sales. Administrative costs are estimated at $562,000. There was no work-in-process inventory, whether opening or ending. The activities’ predicted use is as follows
Activity Cost driver
Ordering 13,500 purchase orders
Machine setup 3,646batches
Materialsmovement 3,646batches
Machine maintenance 7,000 hours
Packaging 3,646,000packages
a Develop the production budget for the coming year. Production is always based on batches of 1,000. To answer this question, please calculate the required production in units and then calculate the production in units rounded to batches of 1,000.
b) Develop the schedule of cost of goods manufactured and the budgeted income statement.Ignore any under or over-applied overhead .
Activity Cost driver Budgeted cost of activity Budgeted levels of cost drivers Ordering Number of purchase order $75,000 15.000 purchaseorders Machine setup Number of batches $134,633 4,000batches Materialsmovement Number of batches $10,637 4,000batches Machine maintenance Machine hours $24,600 7,500hours Packaging and shipping Number of packages $103,125 3,750,000 packages
Step by Step Solution
3.44 Rating (151 Votes )
There are 3 Steps involved in it
Step: 1
Nguyen Nibbles Inc Calculation of ABC rates A B CBA Activity cost pool Cost Driver Cost Quantity ABC rates Ordering Number of purchase order 7500000 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