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
C) 59,500
D) 66,800
Budgeted production = Ending inventory+sales-beginning inventory
Suppose Septemeber's sales = X
we will use August's data
August's production =September's sales*10% + August's sales-Augusts' beginning inventory
56,800 =(X*10%)+56,500-(56,500*10%)
56,800=0.10X + 56,500 -5,650
56,800-56,500+5,650=0.10X
59,500 units
Answer C)
Please up vote if you find this helpful. In case fo query please comment.
Frolic Corporation has budgeted sales and production over the next quarter as follows: July August September...
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)?
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 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 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)...
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...
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...
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...
Osage Inc. has actual sales for May and June and forecast sales for July August September, and October as follows: 5,910 units 6,280 units Actual: May June Forecast: July August September October 5,970 units 6,840 units 5,580 units 5,330 units Required: a. The firm's policy is to have finished goods Inventory on hand at the end of the month that is equal to 75% of the next month's sales. It is currently estimated that there will be 4,478 units on...
Required: 1. Prepare a production budget for Supermix for the months July, August, September, and October. 3. Prepare a direct materials budget showing the quantity of solvent H300 to be purchased for July, August, and September, and for the quarter in total. Complete this question by entering your answers in the tabs below. Required 1 Required 3 Prepare a direct materials budget showing the quantity of solvent H300 to be purchased for July, August, and September, and for the quarter...
XYZ, Inc. has budgeted sales for the first quarter of the next year to be 40,000 units. The inventory on hand at the beginning of quarter is 10,000 units. The desired ending inventory is 1000 units. Calculate the budgeted production for the first quarter. Hospitality, Inc. has prepared the following direct materials purchases budget: Month Budgeted DM Purchases June $68,000 July 79,500 August 78,700 September 77,800 October 70,200 All purchases are paid for as follows: 10% in the month of...