subject
Business, 18.06.2021 04:40 tiffanibell71

Prepare a Master Schedule given the following information: Forecast for each week for an eight-week schedule is 75 units.
The Master Production Schedule (MPS) rule is to schedule production if the projected on-hand inventory would be negative without it.
Committed customer orders are as follows:
WeeWeek CjusCustomer order
1 75
2 53
3 26
4 18
Use a production lot size of 100 units and no beginning inventory.
Week
1 2 3 4 5 6 7 8
Forecast 75 75 75 75 75 75 75 75
Customer Orders 75 53 26 18 0 0 0 0
Projected On-Hand Inventory
MPS
Formulas for Projected On-Hand Inventory
Week 1 = Beginning Inventory + MPS – MAX (Forecast:Customer Order)
Highest number
Weeks 2 – 8 = Previous Week Inventory + MPS – (Forecast: Customer Order)
Because the problem says we cannot have any negative inventory, then we require MPS shipments to come in. When a shipment comes in, it is in lots of 100. In this problem, MPS will be added for Weeks 1,2,3 and Weeks 5, 6, 7. No MPS shipments are expected in Week 4 or Week 8.

ansver
Answers: 1

Another question on Business

question
Business, 22.06.2019 07:40
Xyz corporation has provided the following data concerning manufacturing overhead for july: actual manufacturing overhead incurred $ 69,000 manufacturing overhead applied to work in process $ 79,000 the company's cost of goods sold was $243,000 prior to closing out its manufacturing overhead account. the company closes out its manufacturing overhead account to cost of goods sold. which of the following statements is true? multiple choice manufacturing overhead was overapplied by $10,000; cost of goods sold after closing out the manufacturing overhead account is $253,000 manufacturing overhead was underapplied by $10,000; cost of goods sold after closing out the manufacturing overhead account is $233,000 manufacturing overhead was underapplied by $10,000; cost of goods sold after closing out the manufacturing overhead account is $253,000 manufacturing overhead was overapplied by $10,000; cost of goods sold after closing out the manufacturing overhead account is $233,000
Answers: 1
question
Business, 22.06.2019 08:00
Lavage rapide is a canadian company that owns and operates a large automatic car wash facility near montreal. the following table provides data concerning the company’s costs: fixed cost per month cost per car washed cleaning supplies $ 0.70 electricity $ 1,400 $ 0.07 maintenance $ 0.15 wages and salaries $ 4,900 $ 0.30 depreciation $ 8,300 rent $ 1,900 administrative expenses $ 1,400 $ 0.03 for example, electricity costs are $1,400 per month plus $0.07 per car washed. the company expects to wash 8,000 cars in august and to collect an average of $6.50 per car washed. the actual operating results for august appear below. lavage rapide income statement for the month ended august 31 actual cars washed 8,100 revenue $ 54,100 expenses: cleaning supplies 6,100 electricity 1,930 maintenance 1,440 wages and salaries 7,660 depreciation 8,300 rent 2,100 administrative expenses 1,540 total expense 29,070 net operating income $ 25,030 required: calculate the company's revenue and spending variances for august.
Answers: 3
question
Business, 22.06.2019 16:00
Three pounds of material a are required for each unit produced. the company has a policy of maintaining a stock of material a on hand at the end of each quarter equal to 30% of the next quarter's production needs for material a. a total of 35,000 pounds of material a are on hand to start the year. budgeted purchases of material a for the second quarter would be:
Answers: 1
question
Business, 22.06.2019 16:10
Waterway company’s record of transactions for the month of april was as follows. purchases sales april 1 (balance on hand) 672 @ $6.00 april 3 560 @ $11.00 4 1,680 @ 6.08 9 1,568 @ 11.00 8 896 @ 6.41 11 672 @ 12.00 13 1,344 @ 6.51 23 1,344 @ 12.00 21 784 @ 6.61 27 1,008 @ 13.00 29 560 @ 6.79 5,152 5,936 (a) calculate average-cost per unit. (b) assuming that periodic inventory records are kept in units only, compute the inventory at april 30 using lifo and average-cost. (c) assuming that perpetual inventory records are kept in dollars, determine the inventory using (1) fifo and (2) lifo. (d) compute cost of goods sold assuming periodic inventory procedures and inventory priced at fifo.
Answers: 2
You know the right answer?
Prepare a Master Schedule given the following information: Forecast for each week for an eight-week...
Questions
question
History, 19.05.2020 16:05
question
Arts, 19.05.2020 16:05
question
Mathematics, 19.05.2020 16:05
Questions on the website: 13722361