**Willow Products Sales and Production Budget Analysis**Willow Products expects the following sales of its single product:- March: 5,100 units- April: 6,400 units- May: 7,800 units- June: 8,400 units- July: 9,400 units**Inventory Requirements:**Willow Products desires that the ending finished goods inventory be equal to 20% of the next month’s sales needs. Actual March 1 inventory is projected to be 1,020 units.**Task:**Prepare a production budget for Willow Products for as many months as possible.**Production Budget Table:**| | March | April | May | June | July ||-------------|-------|-------|-----|------|------|| Sales | | | | | || Ending Inv | | | | | || Beginning Inv| | | | | || Production | | | | | |(Note: The cells are to be filled out as part of the task to complete the production budget, incorporating sales projections and inventory strategy.)

Budget means the expected value of future. Budget is not affected by the actual value as it is prepared at the start of any period. Budget is prepared for future and will be compared with actual to get the desired results. Production for given period = Sales + ending inventory – beginning inventory.

Business

Accounting

Wilow Products expects the folowing sales of its single prod 38 Duts r 5,100 4pril 6,100 Kay 1,000 hly 9,400 Wilow Products desires an ending finished goods inventory to be equal to 20% of the next month's sales needs. Actual March hertory is projected to be 1020 units. Aequired Prepare a production budget for Willow Products for as many months as is possible. March April May July Erdrg hv ddon

Wilow Products expects the folowing sales of its single prod 38 Duts r 5,100 4pril 6,100 Kay 1,000 hly 9,400 Wilow Products desires an ending finished goods inventory to be equal to 20% of the next month's sales needs. Actual March hertory is projected to be 1020 units. Aequired Prepare a production budget for Willow Products for as many months as is possible. March April May July Erdrg hv ddon

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

Solve requriement a and b
Vishnu Don't upload image please
both image are same please pull information and answer asap thanks
Mango Place has forecast its sales for the coming months as follows: Standard Units 102 April May June July 121 139 162 The standard model sells for $214. Required: Prepare a sales budget for the quarter ending June 30. Budgeted unit sales Budgeted sales price Budgeted sales revenue Mango Place Sales Budget (Standard Model) For the Quarter Ending June 30 April May June Total
Please do not give solution in image format thanku
Manji
One Device makes universal remote controls and expects to sell 450 units in January, 750 in February, 450 in March, 600 in April, and 650 in May. The required ending inventory is 20% of the next month’s sales. Prepare a production budget for the first four months of the year. One Device Production Budget For the Four Months Ending April 30, 20XX January February March April Expected Sales fill in the blank 1 fill in the blank 2 fill in the blank 3 fill in the blank 4 fill in the blank 6 fill in the blank 7 fill in the blank 8 fill in the blank 9 Total Required Units fill in the blank 10 fill in the blank 11 fill in the blank 12 fill in the blank 13 fill in the blank 15 fill in the blank 16 fill in the blank 17 fill in the blank 18 Required Production fill in the blank 19 fill in the blank 20 fill in the blank 21 fill in the blank 22 Total fill in the blank 23
Please do not give solution in image format thanku
Problem 2. Tyrion Company has the following budgeted production for the 2nd quarter ending in June 30. April May June Quarter Budgeted Production 40,000 50,000 60,000 150,000 Each unit requires 3 pounds of raw material that costs $5.00 per pound. Management desires to end each month with an inventory of raw materials equal to 20% of the following month's production needs. The desired ending inventory for June is 40,000 pounds. Management plans to pay for 60% of raw material purchases in the month acquired and 40% in the following month. In addition, the beginning raw materials inventory for April is budgeted to be 24,000 pounds and the beginning accounts payable for the April is budgeted to be $50,820. Required: a. Prepare the company's direct materials budget and schedule of expected cash disbursements for purchases of materials for the 2nd quarter ending in June. b. If the actual cost of material purchased is $4.5 per pound and 4 pounds of raw materials were purchased to manufacture…
Budget for a merchandising company Nano,inc.is preparing its budget for the second quarter . The following sales data have been forecasted: April. May. June. June July U/sales. 640. 720. 780. 620. 660 Additional information follows: inventory on March 31: 192 units Desired ending inventory each month: 30% of next month's sales. How many units should be produced in April, May and June? How many units should be produced in the second quarter in total? You can Write your answers on this sheet as an excel table or a pasted word documentable.
Surf Inc. has prepared the sales forecast as shown below: Description Month 1 Month 2 Month 3 Month 4 Sales Forecast 25,000.00 27,000.00 29,000.00 23,000.00 Prepare the production budget and show the required production for Months 1-3 Beg Inv Month 1 3,500.00 Required Ending Inventory 15% of the next months budgeted sales Description Month 1 Month 2 Month 3
Part B Tamy Sdn Bhd produces wooden desks. The following estimates are provided for the month of May, June, July and August 2021. Budgeted wooden desk sales in units 8,000 7,000 6,000 5,000 May June July August The estimated selling price is RM120 per unit. Tamy Sdn Bhd wants to have 10% of the next month's sales in units on hand at the end of each month. REQUIRED a) Prepare the sales budget for the month of May, June , July and Total 2021. b) Prepare the production budget for the month of May, June, July and Total 2021.