ZuoTi.Pro
Question

Please provide formula, and process, in excel. QUESTION 1 Frolic Corporation has budgeted sales and production...

Please provide formula, and process, in excel.

QUESTION 1

Frolic Corporation has budgeted sales and production over the next quarter as follow:

July

August

September

Sales in Units

50,000

62,000

??????

Production in units   

71,200

62,300

66,650

The company has 6,000 units of product on hand at July 1. 10% of the next month's sales in units should be on hand at the end of each month.

October sales are expected to be 81,500 units.

Required:

Prepare the Budgeted sales for September in units.

business   accounting   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Calculate budgeted Sales for September

Production Unit = Sales+Desired ending inventory-Beginning inventory

66650 = X+(81500*10%)-(X*.10)

58500 = 0.90X

X(Sales) = 65000

September Sales = 65000 Units

0 0
Add a comment
Know the answer?
Add Answer to:
Please provide formula, and process, in excel. QUESTION 1 Frolic Corporation has budgeted sales and production...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

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

  • Frolic Corporation has budgeted sales and production over the next quarter as follows: July August September...

    Frolic Corporation has budgeted sales and production over the next quarter as follows: July August September Sales in units 41,500 53,500 ? Production in units 42,550 53,800 58,150 The company has 4,300 units of product on hand at July 1. 10% of the next month's sales in units should be on hand at the end of each month. October sales are expected to be 73,000 units. Budgeted sales for September would be (in units):

  • Frolic Corporation has budgeted sales and production over the next quarter as follows: July August September...

    Frolic Corporation has budgeted sales and production over the next quarter as follows: July August September Sales in units 48,500 60,500 ? Production in units 48,850 60,800 65,150 The company has 5,700 units of product on hand at July 1. 10% of the next month's sales in units should be on hand at the end of each month. October sales are expected to be 80,000 units. Budgeted sales for September would be (in units):

  • Frolic Corporation has budgeted sales and production over the next quarter as follows: July August September...

    Frolic Corporation has budgeted sales and production over the next quarter as follows: July August September Sales in units 44,500 56,500 ? Production in units 45,250 56,800 61,150 The company has 4,900 units of product on hand at July 1. 10% of the next month's sales in units should be on hand at the end of each month. October sales are expected to be 76,000 units. Budgeted sales for September would be (in units): Multiple Choice: A) 68,750 B) 68,500...

  • Frolic Corporation has budgeted sales and production over the next quarter as follows September Sales in...

    Frolic Corporation has budgeted sales and production over the next quarter as follows September Sales in units Production in units July 42.00 43,000 August S4, ооо 34, 300 S8,650 the company has 4.400 units of product on hand at July 1 10% of the next month's sales in units should be on hand at the end of each month October sales are expected to be 7500 rsageted September would be in units Round your intermediate calculations to 2 decimal places)...

  • Problem 3: Astro Corporation has budgeted sales and production over the next quarter as follows: July...

    Problem 3: Astro Corporation has budgeted sales and production over the next quarter as follows: July August September Sales in units 44,500 56,500 ? Production in units 45,250 56,800 61,150 The company has 4,900 units of product on hand at July 1. 10% of the next month's sales in units should be on hand at the end of each month. October sales are expected to be 76,000 units. Required: Budgeted sales for September would be (in units)?

  • Frodic Corporation has budgeted sales and production over the next quarter as follows: September Sales in units Prod...

    Frodic Corporation has budgeted sales and production over the next quarter as follows: September Sales in units Production in units July 47,500 63.700 August 59.500 59.800 T 64.150 The company has 5,500 units of product on hand at July 1. 10% of the next month's sales in units should be on hand at the end of each month October sales are expected to be 79.000 units Budgeted sales for September would be in units) 0 72.050 units O 70.100 units...

  • 1. Operating Budgets (50 points) Lubriderm Corporation has the following budgeted unit sales for the next...

    1. Operating Budgets (50 points) Lubriderm Corporation has the following budgeted unit sales for the next six-month period: Month June July August September October November Unit Sales 90,000 120,000 210,000 150,000 180,000 120,000 There were 30,000 units of finished goods in inventory at the beginning of June. Plans are to have an inventory of finished products that equal 20% of the unit sales for the next month. Five pounds of materials are required for each unit produced. Each pound of...

  • 1. Operating Budgets (50 points) Lubriderm Corporation has the following budgeted unit sales for the next...

    1. Operating Budgets (50 points) Lubriderm Corporation has the following budgeted unit sales for the next six-month period: Month June July August September October November Unit Sales 90,000 120,000 210,000 150,000 180,000 120,000 There were 30,000 units of finished goods in inventory at the beginning of June. Plans are to have an inventory of finished products that equal 20% of the unit sales for the next month. Five pounds of materials are required for each unit produced. Each pound of...

  • Answer in excel Problems: 1. Benliver, Inc. manufactures and distributes a number or products to retailers....

    Answer in excel Problems: 1. Benliver, Inc. manufactures and distributes a number or products to retailers. One of these products. Super Jetdry, requires two pounds of material R2D8 in the manufacture of each unit. The company is now planning raw materials needs for the third quarter - July August, and September. Peak sales of Super Jetdry occur in the third quarter of each year. To keep production and shipments moving smoothly, the company has the following inventory requirements: a. The...

  • Roberts Enterprises has budgeted sales in units for the next five months as follows: June July...

    Roberts Enterprises has budgeted sales in units for the next five months as follows: June July August September October 4,600 units 7,600 units 5,400 units 6,900 units 3,800 units Past experience has shown that the ending inventory for each month must be equal to 20% of the next month's sales in units. The inventory on May 31 contained 920 units. The company needs to prepare a production budget for the second quarter of the year. The total number of units...

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