Question

Sales Projections in Units January February 11,769 42,939 31,306 55,150 63,699 March April May $ Projected Sales Price/Unit 4PROJECTED INCOME STATEMENT January February March Sales in Units 31306 11769 42939 $5,860,962.00 Sales Revenue 21383622 15590I got the first two rows but I have no idea how to proceed from here.

If possible please show work

0 0
Add a comment Improve this question Transcribed image text
Answer #1

d Income statement. January I february march Bales in conits 11769 42939 31306 sales Revenue 45060062 $21383622 $15590388 Cos② Direct labour cost Non feb march Tame unit the lhr dhirr Total whits : Por 11769 42939 31306 Total hours 01769 42939 31306- Selling & administrative cost of ra Tan feb march variable costjonie $5 65 1.65 Units 11769 142939 1:31306 variable cost 15

Add a comment
Know the answer?
Add Answer to:
I got the first two rows but I have no idea how to proceed from here....
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Project #2 Sales Projections in Units January February March April May 13.402 45,819 44,164 53,722 52,482...

    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...

    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...

    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...

    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...

    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...

  • Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to plan for the first quarter of that coming year. The company has gathered information from its managers in preparation of the budgeting process.

    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...

    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...

    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...

    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...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT