Question

In: Accounting

Wiley’s electronics has a policy of maintaining a finished goods inventory balance at the end of...

Wiley’s electronics has a policy of maintaining a finished goods inventory balance at the end of a month equal to 30% of the budgeted sales requirements of the following month. The ending inventory balance on 30 January was 840 units, and the projected unit sales for February, March, and April were 4,800, 5,200, and 5,400 units respectively. The labor requirements per unit produced are as follows:

Particulars

Time required (hours)

Rate per hour

Machining

1.8

$23

Sorting

0.9

$18

Assembly

2.2

$22

  1. Prepare a production budget for February and March.
  2. Prepare a direct labor budget for February and March.

Please do not copy from Chegg. Only attempt if you are sure about the answer. Solve in a step by step manner, explaining each step.

Solutions

Expert Solution

The Ending Inventory balance as on 30 January 840 Units
Ending Inventory policy of Wiley's electronic :
= 30 % of Budgeted sale of following month
Projected Sales :
February 4800 Units
March 5200 Units
April 5400 Units
Labour requirement per unit produced :
Time Required Rate per hour
Machining 1.8 $             23.00
Sorting 0.9 $             18.00
Assembly 2.2 $             22.00
a) Production Budget : in Units
January February March April
Opening Inventory 0 840 1560
Sales 4800 5200 5400
Closing Inventory (Note-1) 840 1560 1620
Production (Note-2) 5520 5260
Note-1 : February = 30 % of March Sale = 5200 x 30% = 1560 units
                  March = 30 % of April Sale = 5400 x 30% = 1620 units
Note-2 : February = Sale+Closing inventory-Opeing inventory
                = 4800+1560-840 = 5520 units
                 March = Sale+Closing inventory-Opeing inventory
                = 5200+1620-1560 = 5260 units
b) Direct labor Budget :
Time Required (Hour) Rate per hour February March
Production (Units) 5520 5260
Process :- Machining 1.8 $    23.00 $       2,28,528 $ 2,17,764
(Note-3) Sorting 0.9 $    18.00 $           89,424 $     85,212
Assembly 2.2 $    22.00 $       2,67,168 $ 2,54,584
Total $       5,85,120 $ 5,57,560
Note-3 : Labour cost of each month = Production x time required x rate per hour

Related Solutions

Dido Co.’s finished goods inventory policy is to hold enough inventory at the end of the...
Dido Co.’s finished goods inventory policy is to hold enough inventory at the end of the month to meet 22% of next month’s sales requirements. The cost and selling price of each unit of inventory is $19 and $29, respectively. Dido’s budgeted sales (in units) for the months June through September 20x1 is as follows: June 7510 July 5064 August 9826 September 2192 What is Dido’s budgeted production (in dollars) for the month of August 20x1? Select one: a. $8147...
In a production budget, if the number of units in finished goods inventory at the end...
In a production budget, if the number of units in finished goods inventory at the end of the period is less than the number of units in finished goods inventory at the beginning of the period, then the expected number of units sold is less than the number of units to be produced during the period.  
If finished goods inventory increases between the beginning and the end of the year, then the...
If finished goods inventory increases between the beginning and the end of the year, then the cost of goods sold is smaller than the cost of goods manufactured. true or false
The George Company has a policy of maintaining an end-of-month cash balance of at least $29,000....
The George Company has a policy of maintaining an end-of-month cash balance of at least $29,000. In months where a shortfall is expected, the company can draw in $1,000 increments on a line of credit it has with a local bank, at an interest rate of 12% per annum. All borrowings are assumed for budgeting purposes to occur at the beginning of the month, while all loan repayments (in $1,000 increments of principal) are assumed to occur at the end...
1.The finished goods beginning inventory = $100,000; The finished goods ending inventory = $50,000; The work...
1.The finished goods beginning inventory = $100,000; The finished goods ending inventory = $50,000; The work in process inventory at the beginning of the year was $150,000 and at the end of the year $50,000; The raw materials inventory at the beginning of the year $80,000 and at the end of the year was $40,000. Manufacturing costs and selling and administrative expenses were as follows: indirect materials = $10,000; factory utilities = $20,000; raw material purchases = $30,000 in June...
6. The balance in the Finished Goods Inventory account on July 1, 2007, was $34,000 and...
6. The balance in the Finished Goods Inventory account on July 1, 2007, was $34,000 and the June 30, 2008, balance in the Finished Goods Inventory account was $41,000. If the cost of goods manufactured was $200,000, what was the cost of goods sold?             A.        $285,000            B.        $193,000            C.        $207,000            D.        $278,000 7. Which of the following describes the differences between job-order and process costing? A.        Job-order costing is used in financial accounting while process costing is used in...
Under applied over head 14,000 Finished goods inventory, beginning 310,000 Finished goods inventory, ending 380,000 Raw...
Under applied over head 14,000 Finished goods inventory, beginning 310,000 Finished goods inventory, ending 380,000 Raw materials inventory, beginning 110,000 Raw materials inventory, ending 95,000 Work in process inventory, beginning 105,000 Work in process inventory, ending 85,000 Selling expenses 180,000 Manufacturing overhead Applied 490,000 Direct labor 390,000 Administrative expenses 385,000 Purchases of raw materials 295,000 Sales 2,885,000 Required: 1) Prepare a schedule of Cost of Goods Sold for the year in good form? (Use the table given in the answer...
The four major types of inventory are: excess inventory, WIP inventory, finished goods inventory, and MRO...
The four major types of inventory are: excess inventory, WIP inventory, finished goods inventory, and MRO inventory. A True B False
When there are no units in the beginning Finished Goods Inventory and the units produced are...
When there are no units in the beginning Finished Goods Inventory and the units produced are more than the units​ sold, the operating income will be higher under variable costing than absorption costing.
Bonita Industries has $26000 of ending finished goods inventory as of December 31, 2019. If beginning...
Bonita Industries has $26000 of ending finished goods inventory as of December 31, 2019. If beginning finished goods inventory was $20000 and cost of goods sold was $55000, how much would Bonita report for cost of goods manufactured? $81000 $61000 $20000 $49000
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT