I don't understand the chart for C why is the gross requirement for week 3 is 50, week 5 is 190, and week 6 is 300. We don't use the formulas for my class so I'm confused please use simple math to explai n Week4 67Gross req. 60 20 150Item#AItem#CWhat isneeded#BCсOn hand(beginning)inventory#3565110Quantityneeded121Lot Leadsizing# timeL4L1301L4L 1The three tables above shows the masterproduction schedule and the bill ofmaterials of part A, and the inventoryrecords of all the parts. There are noscheduled receipts. Given thisinformation, what is the planned orderreceipt of part A in Week 7?(Only enter a Find the answers below:WeekGross RequirementsScheduled ReceiptsProject on Hand - 35Projected Available BalanceProduct: AAOH = 35LT = 1 WeekQ=L4LItem: BAOH = 65LT = 1 WeekQ = 30Item: CAOH = 110LT = 1 WeekQ=L4LWeekGross RequirementsScheduled ReceiptsProject on Hand - 65Projected Available BalanceNet RequirementsPlanned Order ReceiptsPlanned Order ReleasesWeekGross RequirementsScheduled ReceiptsProject on Hand - 110Projected Available Balance1 20 00 0Net RequirementsPlanned Order ReceiptsPlanned Order Releases 0 0 25Net RequirementsPlanned Order Receipts0 0oo0 0OOO1 2INolo0 0이이이35 35 35 35 0000ooo30 600003 4 5 6 725 0 20 15000 0000 0 00 00Planned Order Releases 0 0405065 65 65 40 40 20 20000025 00 25 050OOO0 20 1506200700000 0 130 00 150 00 0 150 0 01 2 3 4 5 6 70 0 50 0 190 30020 15020 1500 20 150 00000000 0110 110 110 60 60 000 130 300 00 130 300 0130 300 0 0

The three tables above shows the master production schedule and the bill of materials of part A, and the inventory records of all the parts. There are no scheduled receipts. Given this information, what is the planned order receipt of part A in Week 7?(Only enter a

The three tables above shows the master production schedule and the bill of materials of part A, and the inventory records of all the parts. There are no scheduled receipts. Given this information, what is the planned order receipt of part A in Week 7?(Only enter a

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Q: Predict the number of requests for week 6 using each of these methods: a. Naive. Answer is complete…

A: Given,Week12345Requests2022182122Predict the number of requests for Week 6 using each of these…

Q: Given our current climate, why is spreadsheet proficiency important for employees? Please provide…

A: A person's degree of knowledge, abilities, and ability in using software for spreadsheets, including…

Q: 6- A manufacturing company expects to purchase a new production-line equipment after 3 years. If the…

A: Amount to be set aside each year = 500000 × (AF,4%,3)= 500000 × 0.290731 = 145365.50

Q: The Grand Bakery produces 60 special sourdough rolls every day. Any rolls that are not sold each day…

A: Forecasting is the process of prediction in which sales demand is estimated using historic…

Q: The binary variables in the fixed cost models correspond to: A.) The number of units or products…

A: The binary variable (0s and 1s) in the fixed cost model would correspond to the process for which…

Q: Which of these factors would NOT be needed when prorating an expense? the total of the annual bill…

A: The objective of the question is to identify which of the given factors is not necessary when…

Q: When portraying the power law on a log-log graph, the y-axis is the logarithm of the unit costs, and…

A: A logarithmic function is a vital tool for mathematical calculations. The discovery of logarithms…

Q: You are the supervisor of a department of ten people. You’ve noticed that office supplies are being…

A: In an organization, it is extremely important that the employees follow the code of conduct and…

Q: If Monday actual demand was 5, Tuesday was 2 , Wednesday was 11 and Thursday was 9. The Forecast for…

A: Exponential smoothing is a time series forecasting method for univariate data that could be used to…

Q: PROVER S.A., one of the companies that supplies PRECISIÓN S.A. with raw materials. has asked you to…

Q: Digitech Corporation(DC) pays its employees every two weeks. Eve Anderson, an employee, gets her…

A: A cheque is a type of negotiable instrument that can be indorsed by signing on its back or anywhere…

Q: Staffing is a critical function within an organization, encompassing the identification,…

A: Staffing refers to the process of acquiring, planting, and retaining a pool to negotiate…

Q: An analyst is using a 3-period moving average to forecast the number of widgets needed for the…

A: Since nothing was said about the weight of each period, let's assume all periods have the same…

Q: What would be the outcome of not choosing a percentage when setting the in-office fees?

A: The question is asking about the potential consequences of not selecting a percentage when…

Q: that deal with time series data and describe what type of information that could be learned by…

A: A statistical method known as time series analysis deals with trend analysis and time series data.…

Q: We calculate the three-period moving averages for a time series for all time periods except the:…

A: Forecasting helps in making predictions or assessments regarding future events, trends, or outcomes…

Q: You are an experienced machinist with a small tool shop. You have been asked to submit a bid to…

A: Find the Calculation methods below: Required time (Tn) = T1nbn - Unit numberT1 - Time Taken for…

Q: Lori Cook has developed the following forecasting model: y = 40.0 + 4.20x, where y = demand for Kool…

A: Y = 40 + 4.20x Where, Y = Demand for Air Conditioners X = Outside temperature

Q: A process requires a 20 second setup for each batch. When producing, the process can produce one…

A: Production is the process in which inputs are combined to have the required output. It includes a…

Q: PART II The North Shore Bank is working to develop an efficient work schedule for full-time and…

A: Since full time tellers work 8 hours, they can maximum start their shift by 11am. It is because…

Q: Have you ever had the desire to make a birthday cake instead of buying one? Well, here is how you…

A: Yes , the above process about making a birthday cake is very easy to understand .

Q: a. Compute MAD for each set of forecasts. Given your results, which forecast appears to be more…

A: The forecast is making estimates of future events or trends as per the available information and…

Q: You have an upstream Picking department that feeds two downstream packing departments: A and B. 75%…

A: From the given data, Allocate X people in pack A They are packing for hours = 10 At the rate =…

Q: The manager of a travel agency has been using a seasonally adjusted forecast to predict demand for…

A: Mean absolute deviation determines the prediction's accuracy by averaging the specified inaccuracy…

Q: Using multiple regression, you have identified P12,000 of unit level costs for 3,000 units, P1,000…

A: Cost is the total payment or money incurred to produce products and services in an organization.

Question

I don't understand the chart for C why is the gross requirement for week 3 is 50, week 5 is 190, and week 6 is 300. We don't use the formulas for my class so I'm confused please use simple math to explai n

Week
4 6
7
Gross req. 60 20 150
Item#
A
Item#
C
What is
needed#
B
C
с
On hand
(beginning)
inventory#
35
65
110
Quantity
needed
1
2
1
Lot Lead
sizing# time
L4L
1
30
1
L4L 1
The three tables above shows the master
production schedule and the bill of
materials of part A, and the inventory
records of all the parts. There are no
scheduled receipts. Given this
information, what is the planned order
receipt of part A in Week 7?(Only enter a

Find the answers below:
Week
Gross Requirements
Scheduled Receipts
Project on Hand - 35
Projected Available Balance
Product: A
AOH = 35
LT = 1 Week
Q=L4L
Item: B
AOH = 65
LT = 1 Week
Q = 30
Item: C
AOH = 110
LT = 1 Week
Q=L4L
Week
Gross Requirements
Scheduled Receipts
Project on Hand - 65
Projected Available Balance
Net Requirements
Planned Order Receipts
Planned Order Releases
Week
Gross Requirements
Scheduled Receipts
Project on Hand - 110
Projected Available Balance
1 2
0 0
0 0
Net Requirements
Planned Order Receipts
Planned Order Releases 0 0 25
Net Requirements
Planned Order Receipts
0 0
oo
0 0
OOO
1 2
INolo
0 0
이이이
35 35 35 35 000
0
ooo
3
0 60
0
0
0
3 4 5 6 7
25 0 20 150
0
0 0000 0 0
0 0
0
Planned Order Releases 0 0
4
0
50
65 65 65 40 40 20 20
000
0
25 0
0 25 0
5
0
OOO
0 20 150
620
0
7
0
0
0
00 0 130 0
0 150 0
0 0 150 0 0
1 2 3 4 5 6 7
0 0 50 0 190 300
20 150
20 150
0 20 150 0
0
000000 0
110 110 110 60 60 00
0 130 300 0
0 130 300 0
130 300 0 0

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1: Examine - Given details:

VIEW

Step 2: Calculate - MRP Table

VIEW

Step 3: Calculate - MRP Table

VIEW

Step 4: Explanations:

VIEW

Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 5 steps with 6 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

Consider the following case as you respond to the questions:HSO Corp. designs, manufactures and sells golf carts, scooters and similar vehicles. When a prospective client contacts one of their seven corporate offices, the office manager fills out an "intake questionnaire" to determine if HSO can meet the prospective client's needs. The office manager assembles a team of employees with expertise in design, production, marketing and accounting; the team reviews the intake questionnaire and determines if HSO can take on the order. If so, the office manager prepares a three-page written proposal for the prospective client; the proposal explains the responsibilities of both HSO and the client, along with a timeline and a budget. The proposal is forwarded to the prospective client electronically, and the client has ten calendar days to accept it. If HSO cannot take on the order, the prospective client receives an automatically generated form letter; if the prospective client does not accept…
Describe the importance of the balanced scorecard in achieving the highest ROI.
Hi, I need help determining the answer to this Operations Management problem. Thanks!
Indicate whether the item below is used as key performance indicators for the areas of (A) Financial, (B) Customer, (C) Internal Process, or (D) Learning and Growth performance. Choose the one best choice. Average time from when clients enter and leave the bank (A) Financial(B) Customer(C) Internal Process(D) Learning and Growth performance.
Jose is forecasting project time and cost for constructing a new building by multiplying the total square footage by a given dollar amount. Which of the following methods is he using? Top-down approach B Bottom-up approach Hybrid approach Detailed approach
What does the intercept mean in equation below ? X: C18 (total employees hours worked per week) versus Y: C19 (clinic patients seen per week). Equation: y=0.49x+0.84 Slope:0.49 Intercept:0.84 Does the intercept mean it is 0.84 and predicts how many patients seen if zero hours were workeed. In this case it has no meaning , it is only a line fitting?
Mrs. Peters needed to raise money to bring her class to the Air and Space Museum in Washington, D.C. With only a few weeks left before the deadline, the class was raising an average of $45 every day from online donations. Mrs. Peters was worried they might not raise the last $1,000 in time. That evening, she posted a story about the class trip on an education website, and the donation rate doubled overnight! The new rate stayed the same for the remaining 3 weeks until the deadline, and they raised more than their goal! How much extra did the class raise?
This is for management class, Roshaun is a shipping manager for a company called “Soy to the World” that makes and sells soy candles. The soy candles are made in the company’s production area: mixed by hand and poured into glass jars, labelled, and moved to the shipping department to be sent out all over the country. Customers are usually individuals who find out about the candles from social media. They mostly order small numbers of candles at one time. Sometimes, though, companies order larger amounts of candles to be shipped as a single order. Roshaun’s team consists of eight people who pack and ship orders. Orders arrive via email to the shipping clerk who creates and prints labels, and passes the order to the shipping team that packs the candles into boxes and applies the label. Then the clerk calls an express shipping company to pick up the candles. Roshaun’s team takes such good care of packing each shipment that they have a record of no shipments ever being returned for…
Mop and Broom Manufacturing has tracked the number of units sold of their most popular mop over the past 24 months. This is shown. Month 1 2 3 4 5 6 7 8 Sales Month 238 249 254 267 277 282 402 296 9 10 11 12 13 14 15 16 Sales 300 327 346 349 353 364 373 363 Month + 17 18 19 20 21 22 23 24 Sales 361 381 375 383 384 401 409 403 a. Develop a linear trend line for the data. (Round your answers to 2 decimal places, e.g.,25.28.) Sales = (month) b. Compute a correlation coefficient for the data and evaluate the strength of the linear relationship. (Round your answer to 2 decimal places, the tolerance is +/-0.01.) Correlation coefficient is . It indicates linear relationship. (Use not rounded amounts to answer this question.) c. Using the linear trend line equation, develop a forecast for the next period,month 25. (Round your answer to 2 decimal places, the tolerance is +/-0.01. Do not round intermediate results used to achieve this answer.) Forecast for month 25 =
You have just graduated from the medical technology program and have been hired by a hospital-based laboratory. This is a hospital that you have not trained in and is completely new. You have been hired for the evening shift 4- 12. In detail, explain how you would approach the first 3 months of your employment. The first three months of any new employment is probationary.
When you work for a business that pays on an hourly basis, you are usually required to keep a time card. The time card shows the time you reported for work and the time you departed each day. Total Hours = Sum of Daily Hours Compute the hours worked for each day on the time cards. Round each half of the day to the nearest quarter hour What are the total hours for the week? What is the total pay for the week? 1. DATE TEMPORARY EMPLOYEE TIME CARD NAME. Amanda Tacket OUT IN OUT HOURS 9/137.00 11:00 11.30 4.45 9/14 8.10 11 35 12.30 4.35 9/15 8:10 12.00 12:40 4.10 9/16 8.20 11.50 12 50 450 9/17 7:06 11:09 1150 3:30 EMPLOYEE SIGNATURE RATE per hour $8.50 TOTAL HOURS: DEPT. Accounting Note. No overtime rate. IN
list one example related to the use of statistics to improve a process.