Determine the profit for a week with the current system. You can use the overall structure we discussed in the lesson or develop your own. Regardless of how you develop the model, you will need to validate it in the next couple of questions.


Construct a spreadsheet model to determine the profit for a week with the current system. You can use the overall structure we discussed in the lesson or develop your own. Regardless of how you develop the model, you will need to validate it in the next couple of questions.

Assume for the moment that demand for a week is 5000 and the number ordered the previous Friday was 4000. Compute the profit by hand and verify the answer in your spreadsheet model is correct. 

Now let weekly demand equal order quantity ordered the previous Friday at 5000. Verify the profit from your model is correct.

Finally, test you model for a surplus by letting weekly demand be 4000 and the number ordered the previous Friday be 5000. Again, verify that the spreadsheet is correct.

Construct a two-way data table that displays profit as a function of demand/sales and order quantity. Let both demand and order quantity range from 1,000 to 10,000 in increments of 1,000. Note that all cells are will either reflect a shortage, a surplus, or equal demand and supply.

The post Determine the profit for a week with the current system. You can use the overall structure we discussed in the lesson or develop your own. Regardless of how you develop the model, you will need to validate it in the next couple of questions. appeared first on essaywheel.

[Button id=”1″]

Thanks for installing the Bottom of every post plugin by Corey Salzano. Contact me if you need custom WordPress plugins or website design.

Looking for a Similar Assignment? Our ENL Writers can help. Get your first order at 15% off!

Order

Hi there! Click one of our representatives below and we will get back to you as soon as possible.

Chat with us on WhatsApp