Using the Master Production Schedule grid below, calculate the Projected Available Balance for each Quarter and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Using the Master Production Schedule grid below, calculate the Projected Available Balance for each Quarter and determine what quarter(s) require a Master Production Schedule receipt. + Beginning Inventory = 30 units Production Quantity/Lost Size = 80 units Forecast Projected Available Balance Master Production Schedule Forecast Actual Customer Orders Projected Available Balance Available to Promise Master Production Schedule 6. Available to Promise Calculations a. Utilizing the grid below, calculate the Projected Available Balance for each period and the Available to Promise using the Discrete Method. Beginning inventory = 45 units Production Quantity/Lot Size = 50 units Quarter 1 20 Forecast Actual Customer Orders Projected Available Balance Available to Promise Master Production Schedule 1 20 13 2 20 8 1 20 13 Quarter 2 70 2 20 8 3 20 20 4 30 3 20 20 Quarter 3 70 b. Utilizing the grid below, calculate the Projected Available Balance for each period and the Available to Promise using the Cumulative Method. Beginning inventory = 45 units Production Quantity/Lot Size = 50 units 4 30 5 30 6 30 5 30 Quarter 4 20 6 30 7 30 8 30 7 30 8 30 Using the Master Production Schedule grid below, calculate the Projected Available Balance for each Quarter and determine what quarter(s) require a Master Production Schedule receipt. + Beginning Inventory = 30 units Production Quantity/Lost Size = 80 units Forecast Projected Available Balance Master Production Schedule Forecast Actual Customer Orders Projected Available Balance Available to Promise Master Production Schedule 6. Available to Promise Calculations a. Utilizing the grid below, calculate the Projected Available Balance for each period and the Available to Promise using the Discrete Method. Beginning inventory = 45 units Production Quantity/Lot Size = 50 units Quarter 1 20 Forecast Actual Customer Orders Projected Available Balance Available to Promise Master Production Schedule 1 20 13 2 20 8 1 20 13 Quarter 2 70 2 20 8 3 20 20 4 30 3 20 20 Quarter 3 70 b. Utilizing the grid below, calculate the Projected Available Balance for each period and the Available to Promise using the Cumulative Method. Beginning inventory = 45 units Production Quantity/Lot Size = 50 units 4 30 5 30 6 30 5 30 Quarter 4 20 6 30 7 30 8 30 7 30 8 30
Expert Answer:
Answer rating: 100% (QA)
For the first scenario Discrete Method Quarter 1 Beginning Inventory 30 units Production Quantity 80 units Forecast 20 units Projected Available Balance Beginning Inventory Production Quantity Forecas... View the full answer
Related Book For
Managerial Accounting
ISBN: 978-0176223311
1st Canadian Edition
Authors: Karen Wilken Braun, Wendy Tietz, Walter Harrison, Rhonda Pyp
Posted Date:
Students also viewed these general management questions
-
Refer to Exercise 8.S.6. What conditions are necessary for the confidence interval to be valid? Are those conditions satisfied? How do you know? Exercise 8.S.6 Biologists noticed that some stream...
-
The manager of the customer service department of Omega Credit Card Service Company is concerned about the number of defects produced by the billing process, every day a random sample of 250...
-
Homer Simpson is operating his car at around Noon yesterday. He is stopped for a red-light at the corner of Fast Food Boulevard and 257th Street, on his way to get a burger from Krusty Burger in the...
-
Uniform rod AB of length l and mass m lies in a vertical plane and is acted upon by a couple M. The ends of the rod are connected to small rollers which rest against frictionless surfaces. (a)...
-
PEI Productions Ltd. purchased equipment on February 1, 2015, for $50,000. The company estimated the equipment would have a useful life of three years and would produce 10,000 units, with a residual...
-
Define and explain price leadership, mergers, and entry deterrence.
-
The following financial statements for Blackstone plc are a slightly simplified set of published accounts. Blackstone plc is an engineering business that developed a new range of products in 2011....
-
The following data appeared in the accounting records of Royale Manufacturing Company, which uses an average cost production system: Started in process . . . . . . . . . . . . . . . . . . . . . . . ....
-
Question 15 of 29 (1 point) | Attempt 1 of 13h 18m Remaining Find the missing value. Round your answer to the nearest year. Principal $200,000 Rate Time 2.5% Simple Interest $10,000 years
-
Consider a specimen of ice that is at 210C and 1 atm pressure. Using Figure 9.2, the pressure-temperature phase diagram for H2O, determine the pressure to which the specimen must be raised or lowered...
-
The demand for the handbag is forecasted to follow the following distribution: Demand P(D = d) Demand P(D = d) 6 0.08 15 0.06 7 0.08 16 0.0375 8 0.08 17 0.0375 9 0.08 18 0.0375 10 0.08 19 0.0375 11...
-
In a diverse society made up of many cultures and backgrounds, interpersonal intelligence is a valuable thing to develop. It's the ability to read, empathize, and understand others. When people...
-
Over the years, smith's stockholders have provided $20 million when they purchased newly issued stocks. Currently, the stock is trading at $41 per share and 1 million shares outstanding. What is its...
-
Compare and contrast the platforms of the two major political parties in the United States. Analyze the party's stances on key issues and evaluate the implications those policy stances may have for...
-
You have in your possession numerous resistors with a value of 4.00 m2 each. (a) What is the smallest number you could hook together to get an effective resistance of 1.792 02? (Enter the smallest...
-
Jack Bond, a renowned self-defense instructor working for a local community recreation center, wished to give a real-life learning experience to his students. Unbeknownst to his class, Bond decided...
-
. LFSW099 - Group Activity Module 3A Prompt: How can cross-cultural awareness benefit international students studying in Canada? Task: When you are sure you have understood the prompt, have an...
-
Why do markets typically lead to an efficient outcome for buyers and sellers?
-
You have just begun your summer internship at Tmedic. The company supplies sterilized surgical instruments for physicians. To expand sales, Tmedic is considering paying a commission to its sales...
-
Ariel builds innovative loudspeakers for music and home theatre. Identify the following costs as variable or fixed: a. Depreciation on equipment used to cut wood speaker enclosures b. Wood for...
-
Prepare the direct material budgets for the upcoming three months, assuming that you need to keep 10% of the direct materials needed for next months sales on hand at the end of each month (this...
-
Free subscription warrants are distributed to all the shareholders on a one-for-one basis. The value of each warrant is b. What is the value of the share after the warrant is detached, other things...
-
Will a company with ample growth opportunities tend to issue short-term, mediumterm or long-term debt? Why?
-
If you believe a finance directors main concern is financial flexibility, would you expect a company ever to use up its borrowing capacity?
Study smarter with the SolutionInn App