Homework Help is Here – Start Your Trial Now!
Business
Operations Management
The current data for five trees that will be analyzed in the exercise are shown in the following table Expected Yearly Demand 81 In-Field Quantity 440 165 4 159 0 Trees Christmas Palm Washingtonia Gumbo Limbo Yellow Poinciana Weeping Podo 49 185 Trees Christmas Palm Washingtonia Gumbo Limbo Yellow Poinciana Std Dev 31 155 35 32 68 Quantity For Sale 74 The "expected yearly demand" is an estimate of the demand over the next year for the tree. The "std dev" is the standard deviation, a measure of the error, that corresponds to the forecast. For-sale and in-field quantities are given, and finally the total number of trees planted on the farm. The demand forecast and quantities are updated on an ongoing basis as trees are sold and planted on the farm. trees trees trees trees 374 70 42 290 Your first task is to evaluate the inventory "position" of each tree. The farm does not keep any backorder information, so the only data you have is "for-sale" and "in-field" quantities. Think about "for-sale" as on-hand trees, and "in-field" as on-order trees Calculate the inventory position using two measures: the actual number of trees and an estimate of the years-of-supply for each tree. The current year forecast can be used to estimate years-of-supply. Answer this question by creating two columns that capture this information. Note: Round your "Years-of-Supply" to 1 decimal place. 394 226 Inventory Position Years of Supply Years Years Years Years

The current data for five trees that will be analyzed in the exercise are shown in the following table Expected Yearly Demand 81 In-Field Quantity 440 165 4 159 0 Trees Christmas Palm Washingtonia Gumbo Limbo Yellow Poinciana Weeping Podo 49 185 Trees Christmas Palm Washingtonia Gumbo Limbo Yellow Poinciana Std Dev 31 155 35 32 68 Quantity For Sale 74 The "expected yearly demand" is an estimate of the demand over the next year for the tree. The "std dev" is the standard deviation, a measure of the error, that corresponds to the forecast. For-sale and in-field quantities are given, and finally the total number of trees planted on the farm. The demand forecast and quantities are updated on an ongoing basis as trees are sold and planted on the farm. trees trees trees trees 374 70 42 290 Your first task is to evaluate the inventory "position" of each tree. The farm does not keep any backorder information, so the only data you have is "for-sale" and "in-field" quantities. Think about "for-sale" as on-hand trees, and "in-field" as on-order trees Calculate the inventory position using two measures: the actual number of trees and an estimate of the years-of-supply for each tree. The current year forecast can be used to estimate years-of-supply. Answer this question by creating two columns that capture this information. Note: Round your "Years-of-Supply" to 1 decimal place. 394 226 Inventory Position Years of Supply Years Years Years Years

Practical Management Science
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
icon
Related questions
Question
The current data for five trees that will be analyzed in the exercise are shown in the following table Expected Yearly Demand Quantity For Sale In-Field Quantity 440 74 Trees Christmas Palm Washingtonia Gumbo Limbo Yellow Poinciana Weeping Podo 81 165 159 49 185 Trees Christmas Palm Washingtonia Std Dev 31 155 35 32 68 Gumbo Limbo Yellow Poinciana The "expected yearly demand" is an estimate of the demand over the next year for the tree. The "std dev" is the standard deviation, a measure of the error, that corresponds to the forecast. For-sale and in-field quantities are given, and finally the total number of trees planted on the farm. The demand forecast and quantities are updated on an ongoing basis as trees are sold and planted on the farm. 374 70 42 290 Your first task is to evaluate the inventory "position" of each tree. The farm does not keep any backorder information, so the only data you have is "for-sale" and "in-field" quantities. Think about "for-sale" as on-hand trees, and "in-field" as on-order trees. Calculate the inventory position using two measures: the actual number of trees and an estimate of the years-of-supply for each tree. The current year forecast can be used to estimate years-of-supply. Answer this question by creating two columns that capture this information. Note: Round your "Years-of-Supply" to 1 decimal place. 0 394 226 Inventory Position Years of Supply trees Years trees Years trees Years trees Years Prov 15 of 30 ⠀⠀ Next
Transcribed Image Text:The current data for five trees that will be analyzed in the exercise are shown in the following table Expected Yearly Demand Quantity For Sale In-Field Quantity 440 74 Trees Christmas Palm Washingtonia Gumbo Limbo Yellow Poinciana Weeping Podo 81 165 159 49 185 Trees Christmas Palm Washingtonia Std Dev 31 155 35 32 68 Gumbo Limbo Yellow Poinciana The "expected yearly demand" is an estimate of the demand over the next year for the tree. The "std dev" is the standard deviation, a measure of the error, that corresponds to the forecast. For-sale and in-field quantities are given, and finally the total number of trees planted on the farm. The demand forecast and quantities are updated on an ongoing basis as trees are sold and planted on the farm. 374 70 42 290 Your first task is to evaluate the inventory "position" of each tree. The farm does not keep any backorder information, so the only data you have is "for-sale" and "in-field" quantities. Think about "for-sale" as on-hand trees, and "in-field" as on-order trees. Calculate the inventory position using two measures: the actual number of trees and an estimate of the years-of-supply for each tree. The current year forecast can be used to estimate years-of-supply. Answer this question by creating two columns that capture this information. Note: Round your "Years-of-Supply" to 1 decimal place. 0 394 226 Inventory Position Years of Supply trees Years trees Years trees Years trees Years Prov 15 of 30 ⠀⠀ Next
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 3 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.
SEE MORE TEXTBOOKS