Wright Lighting Fixtures forecasts its sales in units for the next four months as follows: es March April May June 12,000 14,000 11,500 10,000 Wright maintains an ending inventory for each month in the amount of one times the expected sales in the following month. The ending inventory for February (March's beginning inventory) reflects this policy. Materials cost $4 per unit and are paid for in the month after production. Labor cost is $8 per unit and is paid for in the month incurred. Fixed overhead is $15,000 per month. Dividends of $20,600 are to be paid in May. The firm produced 11,000 units in February. Complete a production schedule and a summary of cash payments for March, April, and May. Remember that production in any one month is equal to sales plus desired ending inventory minus beginning inventory. Note: Input all amounts as positive values except Beginning inventory values under Production Schedule which should be entered with a minus sign. Leave no cells blank be certain to enter O wherever required. Wright Lighting Fixtures Production Schedule Projected unit sales Desired ending inventory Total units required March April May June 0 0 Beginning inventory Units to be produced 0 0 0

Wright Lighting Fixtures forecasts its sales in units for the next four months as follows: es March April May June 12,000 14,000 11,500 10,000 Wright maintains an ending inventory for each month in the amount of one times the expected sales in the following month. The ending inventory for February (March's beginning inventory) reflects this policy. Materials cost $4 per unit and are paid for in the month after production. Labor cost is $8 per unit and is paid for in the month incurred. Fixed overhead is $15,000 per month. Dividends of $20,600 are to be paid in May. The firm produced 11,000 units in February. Complete a production schedule and a summary of cash payments for March, April, and May. Remember that production in any one month is equal to sales plus desired ending inventory minus beginning inventory. Note: Input all amounts as positive values except Beginning inventory values under Production Schedule which should be entered with a minus sign. Leave no cells blank be certain to enter O wherever required. Wright Lighting Fixtures Production Schedule Projected unit sales Desired ending inventory Total units required March April May June 0 0 Beginning inventory Units to be produced 0 0 0

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

The Porch Cushion Company manufactures foam cushions. The number of cushions to be produced in the upcoming three months follows: Number of foam cushions to be produced in July Number of foam cushions to be produced in August Number of foam cushions to be produced in September Each cushion requires 2 pounds of the foam used as stuffing. The company has a policy that the ending inventory of foam each month must be equal to 30% of the following month's expected production needs. How many pounds of foam does The Porch Cushion Company need to purchase in August? OA. 20,800 OB. 15,400 13,000 11,000 9,000 OC. 27,400 OD. 28,600
E
Cousin Eddy provides you with his sales forecast for the next four months: April May 750 June July 790 Sales (Units) 670 The company wants to end each month with ending finished goods Inventory equal to 40% of next month's forecasted sales. Finished goods inventory on April 1 is 268 units. Assume July's budgeted production is 700 units. In addition, each finished unit requires four pounds of raw materials and the company wants to end each month with raw materials inventory equal to 30% of next month's production needs. Beginning raw materials inventory for April was 842 pounds. Assume direct materials cost $5 per pound. Required: For May, how many units must be produced? (Hint: This is your production budget) Submit your answer below 700 with all work submitted via email.
The production planning team of Red Velvet Inc showed that each product requires 3 units of raw materials costing 10 each. The inventory manager requires that 20% of the total raw materials purchased during the month must be kept as monthly ending inventory to avoid shortage The marketing team estimates that the demand of the product is 10,000 units in September 12,000 units in October, and 15,000 units in November. The starting inventory in September for the raw materials is 7,200 units. 1. What is the total units of raw materials needed to be purchased on the month of September to meet the requirements of different departments? 2. What is the total units of raw materials needed for the production of October estimated demand?
On January 1 the company had 330 widgets in finished good inventory. The company policy is to maintain an inventory of 15% of next montha sales. The company forecast the following sales: Jan. 2,200 Feb. 2,800 March 3,500 April 4,000 Determine the required production for January?
Data Trevor Cycles manufactures chainless bicycles. On March 31, Trevor Cycles had 206 bikes in inventory. The company has a policy that the ending inventory in any month must be 20% of the following month's expected sales. Trevor Cycles expects to sell the following number of bikes in each of next four months: View the data. Prepare a production budget for the second quarter, with a column for each month and for the quarter. Trevor Cycles Production Budget For the Months of April through June April.. 1,030 bikes April May June Quarter May 1,170 bikes les 1030 1170 1390 1270 206 234 278 254 June.. 1,390 bikes esired ending inventory July 1,270 bikes eeded 1236 1404 1668 4308 206 206 234 646 Beginning inventory 1030 1198 1434 3662 o produce Print Done
Li Company manufactures a product requiring 2 pounds of raw material for each finished unit. Raw materials inventory had a balance of on March 1 was 7,000 pounds. The company wants to maintain an ending inventory equal to 40% of the next month’s production needs. Production for March and April is projected to be 4,000 and 5,000 units, respectively. How many pounds of raw material must be purchased in March?
Trago Company manufactures a single product and has a JIT policy that ending inventory must equal 10% of the next month's sales. It estimates that May's ending inventory will consist of 29,600 units. June and July sales are estimated to be 296,000 and 306,000 units, respectively. Trago assigns variable overhead at a rate of $3.40 per unit of production. Fixed overhead equals $416,000 per month. Compute the budgeted total factory overhead for June.
Trago Company manufactures a single product and has a JIT policy that ending inventory must equal 10% of the next month's sales. It estimates that May's ending inventory will consist of 28,200 units. June and July sales are estimated to be 282.000 and 292.000 units, respectively. Trago assigns variable overhead at a rate of $2.00 per unit of production. Fixed overhead equals $402.000 per month. Compute the total budgeted overhead for June Multiple Choice $978,000. $968.000 $566.000. $966.000. $986,000
Ecology Co. sells a biodegradable product called Dissol and has predicted the following sales for the first four months of the current year: Sales in units O 3,010 O 3,100 O 3,190 O 2,830 O 3,700 Jan. 2,500 Ending inventory for each month should be 15% of the next month's sales, and the December 31 inventory is consistent with that policy. How many units should be purchased in February? Question 8 Feb. 3,100 March. 3,700 April. 2,800 F6 F7 F8
MAXI Co. has the following information: *Projected sales for four (4) months are as follows: July-20,000 units; August -35,000 units ; September-25,000; October-30,000. Sales price per unit is $180 *Plans are to have a finished goods inventory end equal to 20% of the unit sales for next month. There was 4,000 units in beginning inventory on July 1. *Three (3) kilos of materials are required per unit produced. Every kilo of material is $20. Raw material inventory must be equal to 30% of the next month's needs . Desired ending inventory for September is 25,200 kilos and beginning inventory was 20,700 kilos. *Each unit requires 0.60 hours of direct labor and the average wage rate is $16 per hour. *Variable overhead rate is $3.50 per direct labor hour. There is also a fixed overhead of $22,000 per month. *The company pays 3% commission on sales. *Company has a monthly fixed and selling expenses as follows: Rent-$6,000 ; Utilities-$1,200 ; Advertising-$400: Office Salaries-$35,000.…
Jarash, Inc. anticipates sales of 121758 units, 150 000 units, and 160.000 units in July. August, and September, respectively. Company policy is to maintain an ending finished-goods inventory equal to 40% of the following month's sales. On the basis of this information, how many units would the company plan to produce in July? 181758 units