Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please answer # 1-3 !!! Mnt Supply Inc, selis ski goggles for those who are forgetful. The company purchases from a Chinese manufacturer at the

Please answer # 1-3 !!!
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Mnt Supply Inc, selis ski goggles for those who are forgetful. The company purchases from a Chinese manufacturer at the beginning of the summer. Due to shipping time, the company only order once a year. Mnt purchases the goggles for $5.00 and sells them at $15.00. Since the store closes at the end of ski season, any leftover goggles are sold for $3.00 on a website, From historical data. Mnt Supply estimated demand is following a Poisson distribution with a mean of 160. The company considers ordering anywhere from 130 units to 180 units with an increment of 10 units. Consider Mnt Supply Inc problem statement. The screenshot above represents a completed simulation model. Complete the function in Cell C10 representing "Order Quantity. Consider Mnt Supply Inc problem statement. The screenshot above represents a completed simulation model, Complete the function in Cell C16 representing "Units Sold in Season:" \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Unit Cost $5} \\ \hline 4 & & Selling Price & $15 & \\ \hline 5 & & Salvage Price & $3 & \\ \hline 6 & & & & \\ \hline 7 & & Expected Demand & 160 & \\ \hline 8 & & & & Potential Order Quantity \\ \hline 9 & \multicolumn{3}{|c|}{ Decision Variables } & 130 \\ \hline 10 & & Order Quantity & & 140 \\ \hline 11 & & & & 15 \\ \hline 12 & \multicolumn{2}{|c|}{ Random Variable } & & 160 \\ \hline 13 & & Demand & & 170 \\ \hline 14 & & & & 180 \\ \hline 15 & \multicolumn{4}{|l|}{ Calculations } \\ \hline 16 & & \multicolumn{3}{|l|}{ Units Sold in Season } \\ \hline 17 & & \multicolumn{3}{|l|}{ Units Salvaged } \\ \hline \multicolumn{5}{|l|}{18} \\ \hline 19 & & \multicolumn{3}{|l|}{ Regular Revenue } \\ \hline 20 & & \multirow{2}{*}{\multicolumn{3}{|c|}{ Salvage Revenue }} \\ \hline \multicolumn{2}{|l|}{21} & & & \\ \hline 22 & & \multirow{2}{*}{\multicolumn{3}{|c|}{ Total Cost }} \\ \hline \multicolumn{2}{|l|}{23} & & & \\ \hline 24 & & \multicolumn{3}{|l|}{ Profit } \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Lease Audits The Essential Guide

Authors: Theodore H Hellmuth

1st Edition

0934055041, 978-0934055048

More Books

Students also viewed these Accounting questions