Business

In our discussion of the “order-up-to model” in class, we assumed that the excess demand is backordered. That is, if the demand in any period is larger than the on-hand inventory at the beginning of the period, we hold on to the excess demand (which is why our inventory at the end of a period can be negative) and meet it when an order arrives at the beginning of the next period.
In this question, you will compare the backordering assumption with an alternative assumption, under which excess demand becomes lost sales. That is, if the demand in any period is larger than the on-hand inventory, the excess demand in that period is lost forever.
Consider a firm ABC, which makes and sells Product Z. ABC manages the inventory of Product Z according to an order-up-to policy with periodic review. The production lead time for Product Z is five days. ABC reviews the inventory of Product Z at the beginning of each day, and uses a constant
order-up-to level of 180 for Product Z’s inventory position. That is, at the beginning of each day, ABC starts producing enough of Z to bring its inventory position to 180. As for the daily demand for Product Z, we are given 45 days of demand observations – see “Question 3 Product Z Demand Data.xlsx.”
(a) Assume that the excess demand for Product Z is backordered. Run a simulation (with 5000 iterations) that tracks Product Z’s inventory over 100 days. Determine the average cycle service level and average leftover inventory per day for Product Z.
Hints and Guidance: (i) See the template “Question 3 Backorder — Template.xlsx.” do the template to answer part (a). (ii) Do not change any of the data for days -4 through 0; those indicate what happened prior to Day 1. (iii) Note that we do not know the probability distribution of the daily demand for Product Z, but we are given 45 days of demand data in “Question 3 Product Z Demand Data.xlsx.” Therefore, first, fit a distribution to the daily demand data, using @RISK’s “Fit” feature. One suggestion: When you are doing the fit, choose “Continuous Sample Data” as your data type. Because the demand numbers are relatively large, there is no harm in approximating it as a continuous variable that can take fractional values. (iv) To determine the number of days without shortages, you can use Excel’s “Countif” function.
(b) Now, assume that the excess demand for Product Z becomes lost sales. Run a simulation that tracks Product Z’s inventory over 100 days, across 5000 iterations. Determine the average cycle service level and average leftover inventory per day for Product Z.
Hints and Guidance: Revise the spreadsheet for the backorder case to model this alternative scenario. To revise, think about the following question: Under the lost sales assumption, if the demand exceeds on-hand inventory, what is the inventory at the end of the day?
(c) Compare your results for parts (a) and (b), answer the following question: Which assumption led to a higher cycle service level – backordering or lost sales? Why do you think that is?
The needed templates are in the below links.
https://www.dropbox.com/scl/fi/42h70v2sfta2f7z0n4esw/Backorder-Template.xlsx?dl=0&rlkey=85h31wnk82gazzv73aucz86uh
https://www.dropbox.com/scl/fi/fhz3qx2gvyocrav0kwqmk/Product-Z-Demand-Data.xlsx?dl=0&rlkey=fp7at0suu6hi4jryr2kz9oe1n

My MasterPapers
Calculate your paper price
Pages (550 words)
Approximate price: -

Why Us

Outstanding Academic Writing Service

At MyMasterPapers.com, you are assured of professional essay writing help from the leading experts online. Quality comes at the forefront of our custom writing service to ensure that all our customers are satisfied with the work delivered. We value repeat customers. For this reason, we ensure that each task is completed to perfection for high scores.

Top Writers

Our hiring process is highly intensive. The writers are exposed to a strict selection procedure before hiring to ensure that we acquire the most qualified, well-educated and experienced writers. Our team of writers, professors, editors and researchers will ensure that you get incredible results.

Plagiarism-Free Papers

We highly discourage plagiarism. For this reason, we have trained our writers in such a way that all the papers are written from scratch and are free from plagiarism. We also pay attention to ensure that each paper is completed as per the instructions provided. Referencing and citations are done as per the paper format selected by the customer. These include: APA, MLA, Chicago, Harvard, Turabian among others.

24/7 Customer Support

You can contact our support team via the chat window at the bottom right corner. Alternatively, feel free to email us via our support email: support@mymasterpapers.com. Our team is available 24/7 to respond to your queries and guide you though where need be.

Swift Delivery & 100% Money Back Guarantee

Simply choose the desired deadline when placing the order. The task is assigned to the most qualified writer as soon as the order is successfully placed. All the papers are delivered to you within the deadline selected. In case a paper cannot be delivered within the deadline selected, we request for a deadline extension within the shortest time possible.

Free Unlimited Revisions

Our customers can always request for a revision in case they feel that something needs to be added or changed after the final paper has been delivered. We do not charge for revisions. However, we highly discourage our customers from misusing this policy.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Mymasterpapers.com specializes in custom essay writing for all level of students. Simply relax as we get your paper done within the timeline indicated.

Essays

Academic Help Service

Our team of skilled writers and researchers is readily available to get any type of academic paper completed. We deliver high quality papers and projects to our customers to ensure that we maintain a long-term relationship that will shine your academic career.

Admissions

Admission Essays & Professional Writing

An admission essay allows you to express yourself by providing personal details that wouldn’t have fit on other areas of an application. We have a team of experienced writers who will get you to the desired academic level through a professional and a personalized admission essay.

Reviews

Editing & proofreading

Are you seeking for editing or proofreading help? We have a team of editors who will ensure that any issue within you paper has been addressed. Upload the paper to be cleaned up and relax as we get the job done.

Reviews

Revision Support

At mymasterpapers.com, you can always ask for revision in case you want some changes in you paper. We focus on ensuring that the grammar, research and formatting are done as per the latest academic writing standards.