1. Using the Fitter sales forecast for January through December given in the table below, develop...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Using the Fitter sales forecast for January through December given in the table below, develop a spreadsheet for sales and operations planning for the whole year. Use the format of the spreadsheet similar to the one shown in Figure 4-5 ( text book-Concept in Enterprise Resource Planning). The highest level of capacity utilization is 95 percent in any month. In case the demand is higher, inventory has to be built up in the previous months to deal with the increased demand in certain month. March April May July 6476 7128 S&OP Dec. Jan. Feb. June Aug. Sep. Oct. Nov. Dec. 1) Sales forecast 5906 5998 6161 6421 6897 6517 6401| 6329 6133 5987 2) Production plan 3) Inventory 4) Working days 100 21 20 23 21 21 22 20 23 21 21 20 21 5) Capacity (shipping cases) 6) Utilization 7) NRG-A (cases) 70% 8) NRG-B (cases) 30% Please select the correct answers. Select one or more: a. The inventory level for March and Aug are 388 and 93 respectively b. The inventory level for March and Aug are 427 and 102 respectively C. The production plan for April and Sep are 6539 and 6499 respectively. d. The inventory level for March and Aug are 457 and 128 respectively e. The production plan for April and Sep are 6571 and 6504 respectively. f. The production plan for April and Sep are 6489 and 6344 respectively. g. If the NRG-A (case) is 4561 in Aug, then the Utilization percentage should be 88 percent. h. If the NRG-A (case) is 4561 in Aug, then the Utilization percentage should be 82.7 percent. i. The production plan for April and Sep are 6649 and 6404 respectively. BACK TO TOP j. If the NRG-A (case) is 4561 in Aug, then the Utilization percentage should be 85 percent. 1. Using the Fitter sales forecast for January through December given in the table below, develop a spreadsheet for sales and operations planning for the whole year. Use the format of the spreadsheet similar to the one shown in Figure 4-5 ( text book-Concept in Enterprise Resource Planning). The highest level of capacity utilization is 95 percent in any month. In case the demand is higher, inventory has to be built up in the previous months to deal with the increased demand in certain month. March April May July 6476 7128 S&OP Dec. Jan. Feb. June Aug. Sep. Oct. Nov. Dec. 1) Sales forecast 5906 5998 6161 6421 6897 6517 6401| 6329 6133 5987 2) Production plan 3) Inventory 4) Working days 100 21 20 23 21 21 22 20 23 21 21 20 21 5) Capacity (shipping cases) 6) Utilization 7) NRG-A (cases) 70% 8) NRG-B (cases) 30% Please select the correct answers. Select one or more: a. The inventory level for March and Aug are 388 and 93 respectively b. The inventory level for March and Aug are 427 and 102 respectively C. The production plan for April and Sep are 6539 and 6499 respectively. d. The inventory level for March and Aug are 457 and 128 respectively e. The production plan for April and Sep are 6571 and 6504 respectively. f. The production plan for April and Sep are 6489 and 6344 respectively. g. If the NRG-A (case) is 4561 in Aug, then the Utilization percentage should be 88 percent. h. If the NRG-A (case) is 4561 in Aug, then the Utilization percentage should be 82.7 percent. i. The production plan for April and Sep are 6649 and 6404 respectively. BACK TO TOP j. If the NRG-A (case) is 4561 in Aug, then the Utilization percentage should be 85 percent.
Expert Answer:
Answer rating: 100% (QA)
Capacity each month is calculated in term of month of shopping 200bars per numbers 60minutes per hou... View the full answer
Related Book For
Project Management A Managerial Approach
ISBN: 978-0470226216
7th Edition
Authors: Jack R. Meredith, Samuel J. Mantel,
Posted Date:
Students also viewed these general management questions
-
Develop a spreadsheet for Problem 9. (a) What would your recommendation be if the weight for the implementation risks went down to 10 and the weight of cultural differences went up to 25? (b) Suppose...
-
Develop a spreadsheet for Muskingum routing using the given inflow hydrograph through the river reach, where K = 2 hr, x = 0.15, and t = 2 hr. Time (hr)Inflow (m3/s) 0..............................60...
-
If you had a 15,000 pesos budget for 30 days, considering you also pay utilities, how would you budget it with the following expenses: a. consumption (food) b. clothing c. health d. savings Explain...
-
(You can use other websites for this question) The Chicago Bulls realize that they've sucked since the 90s because they have relied on one start player for too long (Jordan, Rose), and that Machine...
-
Find the range, mean, median, and mode for the following. Round to the nearest hundredth if necessary. 1. New car mileages 17 mi/gal 16 mi/gal 25 mi/gal 22 mi/gal 30 mi/gal 2. Sandwiches $0.95...
-
P(C|E) Find the indicated probabilities by referring to the given tree diagram and by using Bayess Rule. A P(A) = 0.2 P(E|A)=0.6 E P(ECA) = 0.4 -EC P(B) = 0.55 P(E|B)=0.7 -E B EC P(E|B) = 0.3 P(C) =...
-
To study the effect of using digital devices in the classroom on exam performance, researchers divided 726 undergraduate students into three groups, including a group that was allowed to use digital...
-
Analysis of return on invested assets, comparison of two divisions, DuPont method. Global Data, Inc., has two divisions: Test Preparation and Language Arts. Results (in millions) for the past three...
-
Identify and evaluate the components of a comprehensive total rewards and motivation system? Illustrate with specific examples.
-
The proposed rates were not in the range the CEO expected given the pricing analysis. The CEO has asked the pricing actuary to verify the total projected loss cost excluding potential large storm...
-
Complete the table below. Assume f and g are one-to-one functions. f(x) g(x) -10 -3 15 (fog)(x) (gof)(x) 1 -3 15 1 -10 10 15 -10 15
-
Consider a three-period financial market with t = 0,1,2,3 and a down-and-out call barrier option with barrier H = 90 and strike K = 110. (a) Draw a binomial tree for the possible values of...
-
According to the accounting financial statement below: Qwerty, Inc 2017 Income Statement ($ in millions) Net sales Less: cost of goods sold (COGS) Less: Depreciation expense Earnings before interest...
-
Discuss your thoughts on the legal guidelines regarding ethical health issues.
-
Based on the excellent job that you did for hospice care, you have been appointed to a board of directors to regulate the aging service industry. Some of these service providers include nursing...
-
John Fleming, chief administrator for a district hospital, is concerned about costs for tests in the hospital's lab. Fleming has asked you to evaluate costs for the past month. The following...
-
Josie Is Buying A Samsung Refrigerator And With No Down Payment She Borrows $12000 To Finance The Purchase The Appliance. She Agrees To Repay By Making Equal Monthly Payments For 2 Years At 1.82%...
-
Reichenbach Co., organized in 2018, has set up a single account for all intangible assets. The following summary discloses the debit entries that have been recorded during 2018 and 2019. Instructions...
-
How can an auditor/evaluator avoid the shortfalls described in the article? MINI CASE Overall, in the light of this study, we would come out strongly in favor of post-project reviews (provided you do...
-
In Table 1 , which of the problems are related to project setup (perhaps occurring before a project manager was selected) and which are related to the project managers skills? Effective Resolution...
-
Given the following project to landscape a new building site, (a) Draw a Gantt chart using MSP. (b) Find the critical path and project duration in days. (c) Given that each resource is assigned 100%...
-
For many years, womens professional basketball struggled for consistency in the United States. Since 1978, when the Womens Professional Basketball League (WBL) was formed, leagues have had difficulty...
-
What are the five forms of financing, and how is each used within sport?
-
That financial ratios are most valuable when viewed in comparison to the organizations historical ratio values and competitors values. Why is this context valuable when examining financial ratio...
Study smarter with the SolutionInn App