I got the first two rows but I have no idea how to proceed from here.
If possible please show work
I got the first two rows but I have no idea how to proceed from here....
Project #2 Sales Projections in Units January February March April May 13.402 45,819 44,164 53,722 52,482 Projected Sales Price/Unit $ 450.00 Monthly Projected Selling & Administrative Expenses Variable Cost/Unit $16.00 Fixed Costs $5,519 Production: Desired Ending Inventory Beginning Inventory (new business) 59.0% 0 64.6% Materials Desired Ending Inventory Number of Materials per Unit Projected Cost/Material Unit Beginning Inventory (new business) 11.0 $23.00 0 Direct Labor Time per Unit (in hours) Cost per Hour 1.00 $21.00 Manufacturing Overhead Variable Cost/Unit $5.00...
Excel 2010 Help 1) create sales budget 2) operating budget 3) production budget 4) material req budget 5) direct labor budget 6) manuf overhead budget 7) production per unit 8) projected income statement AB ales Projections In Units January February March April 20,609 26,521 27,815 49,644 47,350 Projected Sales Price/Unit $ 198.00 Monthly Projected Selling & Administrative Expenses Variable Cost/Unit Fixed Costs $5.00 $5,854 Production: 22.4% Desired Ending Inventory Beginning Inventory (new business) Materials 12.2% 14.0 Desired Ending Inventory Number...
Managerial Accounting Can anyone Help me with these, and include the calculations in order for me not to hardcode the numbers because I need to use the excel formulas. Thank you Project #2 Sales Projections in Units January February March April |May 13,402 45,819 44,164 53,722 52,482 Projected Sales Price/Unit $ 44.00 Monthly Projected Selling & Administrative Expenses Variable Cost/Unit $16.00 Fixed Costs $5,519 Production: Desired Ending Inventory Beginning Inventory (new business) 59.0% 0 Materials 64.6% 11.0 Desired Ending Inventory...
Wright Lighting Fixtures forecasts its sales in units for the next four months as follows: March 28,000 April 30,000 May 27,500 June 26,000 Wright maintains an ending inventory for each month in the amount of one and one-half times the expected sales in the following month. The ending inventory for February (March's beginning inventory) reflects this policy. Materials cost $5 per unit and are paid for in the month after production. Labor cost is $9 per unit and is paid...
Trebblehorn Industries has adopted the following sales budget for the first 3 months of 2017. Month Units January 11,000 February 15,000 March 13,000 Management requires 30% of next month sales to be in ending inventory. Each unit requires 5 pounds of raw materials costing $3 per pound. Management wants to have a raw materials inventory at the end of the month equal to 35% of next month's production requirements. April's expected sales are 12,000 with a total of 13,500 required...
SalesUnit sales for November 2019114,000Unit sales for December 2019103,000Expected unit sales for January 2020114,000Expected unit sales for February 2020111,000Expected unit sales for March 2020116,000Expected unit sales for April 2020125,000Expected unit sales for May 2020136,000Unit selling price$12Waterways likes to keep 10% of the next month’s unit sales in ending inventory. All sales are on account. 85% of the Accounts Receivable are collected in the month of sale, and 15% of the Accounts Receivable are collected in the month after sale. Accounts...
please help 3 Wright Lighting Fixtures forecasts its sales in units for the next four months as follows: March April May June 28,000 30,000 27,500 26,600 Book Hint Wright maintains an ending inventory for each month in the amount of one and one-half times the expected sales in the following month. The ending inventory for February (March's beginning inventory) reflects this policy. Materials cost $5 per unit and are paid in the month after production. Labor cost is $9 per...
Stenback Manufacturing produces self-watering planters for use in upscale retail establishments. Sales projections for the first five months of the upcoming year show the estimated unit sales of the planters each month to be as follows: (Click the icon to view additional information.) Inventory at the start of the year was 800 planters. The desired inventory of planters at the end of each month should be equal to 25% of the following month's budgeted sales. Each planter requires two pounds...
Wright Lighting Fixtures forecasts its sales in units for the next four months as follows: March 27,000 April 29,000 May 26,500 June 25,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...
Developing a Master Budget for a Manufacturing Organization Jacobs Incorporated manufactures a product with a selling price of $50 per unit. Units and monthly cost data follow: Variable: Selling and administrative $5 per unit sold Direct materials 10 per unit manufactured Direct labor 10 per unit manufactured Variable manufacturing overhead 5 per unit manufactured Fixed: Selling and administrative $20,000 per month Manufacturing (including depreciation of $10,000) 30,000 per month Jacobs pays all bills in the month incurred. All sales are...