Scribd
Upload
4 views5 pages

Cost Analysis and Profit Simulation

This document contains cost and demand data for a product along with possible order quantities and simulation results. It lists the unit cost, unit price, and sale price for the product. It provides the minimum, maximum, and most likely demand quantities. It then shows possible order quantities to simulate and the results of simulations run for those order quantities, including minimum, maximum, and average profits. The simulation results for order quantities of 150, 175, and 200 are blank, with the profit for 150 shown as 375.

Uploaded by

Arti Rahangdale
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
4 views5 pages

Cost Analysis and Profit Simulation

This document contains cost and demand data for a product along with possible order quantities and simulation results. It lists the unit cost, unit price, and sale price for the product. It provides the minimum, maximum, and most likely demand quantities. It then shows possible order quantities to simulate and the results of simulations run for those order quantities, including minimum, maximum, and average profits. The simulation results for order quantities of 150, 175, and 200 are blank, with the profit for 150 shown as 375.

Uploaded by

Arti Rahangdale
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Cost data Demand distribution

Unit cost1 ₹ 7.50 Regular Sale Supply


Unit cost2 ₹ 7.25 Min 100 0.00 120
Unit price ₹ 10.00 Max 300 70.00 240
Sale price ₹ 6.00 Most likely 172 50.00 200

Decision variable Possible order quantity


Order quantity 150 150 175 200

Max supply Regular dema Sale demand Actual supply


194 193 19 150

Simulation 1 2 3 4 5 6
150 175 200 225 250 275
Minimum profit 375 #NAME? #NAME? #NAME? #NAME? #NAME?
Maximum profit 375 #NAME? #NAME? #NAME? #NAME? #NAME?
Average profit 375 #NAME? #NAME? #NAME? #NAME? #NAME?
Std. Dev of profit 0 #NAME? #NAME? #NAME? #NAME? #NAME?
5 percentile profit 375 #NAME? #NAME? #NAME? #NAME? #NAME?
95 percentile profit 375 #NAME? #NAME? #NAME? #NAME? #NAME?
225 250 275

Revenue Cost Leftover Sale Reven Profit


1500 1125 0 0 375

You might also like