Find Jobs
Hire Freelancers

Spreadsheet model for a small business problem

$25-55 USD

Suoritettu
Julkaistu yli 5 vuotta sitten

$25-55 USD

Maksettu toimituksen yhteydessä
Igam's shoppe buys products each week from nearby city. Orders are placed online on Saturday night, and early Monday morning products arrive at the airport in a box refrigerated with dry ice. The products cost $8 a dozen and are sold on a cash-and-carry basis for $28 a dozen. Products left over at the end of the week are put in a trash collector in an alley behind the store. Past sales (rounded to the neares ten dozen) are as follows: Dozens of Products Relative Demanded Frequency ---------------- --------------- 110 5 120 20 130 25 140 30 150 20 Igam wants to compare two ordering rules for ordering products: 1. order last week's demand plus 10 dozen extra (as safety stock), 2. order 130 dozen every week. He wants to run an eight week simulation to compare the average weekly profit for the two rules. Last week's demand was for 110 dozen. He generated the following random numbers for weeks 1-8, respectively: 63,13,67,50,71,25,44 and 00. a. What is the random number range corresponding to each of the five demand quantities? b. Simulate eight weeks of operation using each of the ordering rules and compute the average weekly profit resulting from each rule. Create a spreadsheet model in Excel for the above problem. Rerun the model for 100 weeks of operation and 500 weeks of operation (trials) using random numbers you generate, rather than the random numbers supplied above. Compare the average weekly profit for the 8 week simulation, 100-week simulation and 500-week simulation. What conclusions do you draw?
Projektin tunnus (ID): 18339856

Tietoa projektista

2 ehdotukset
Etäprojekti
Aktiivinen 5 vuotta sitten

Haluatko ansaita rahaa?

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu
Saa maksu työstäsi
Kuvaile ehdotustasi
Rekisteröinti ja töihin tarjoaminen on ilmaista
Myönnetty käyttäjälle:
Käyttäjän avatar
Hello, We are two management accountants (CPA, ACMA, CGMA), full time employed in Australia. Our service priorities are; 1. Complete information security - We value your information as you do. 2. Highest Quality - Professional service is guaranteed. 3. 100% Accuracy - We apply only if we are capable to do it. 4. On time delivery - We value your time. 5. Flexibility - We are open for modifications, changes and improvements. We are new to this website, therefore we provide services for a competitive price as we need your feedback and reviews to grow our business. Please refer our LinkedIn profiles for more information. Ranga - [login to view URL] Sachith - [login to view URL] We are looking forward to hearing from you. Yours faithfully, Sachith J. informatikz Team
$25 USD 1 päivässä
4,6 (3 arvostelua)
2,3
2,3
2 freelancerit tarjoavat keskimäärin $28 USD tätä projektia
Käyttäjän avatar
Igam's shoppe buys products each week from nearby city. Orders are placed online on Saturday night, and early Monday morning products arrive at the airport in a box refrigerated with dry ice. The products cost $8 a dozen and are sold on a cash-and-carry basis for $28 a dozen. Products left over at the end of the week are put in a trash collector in an alley behind the store. Past sales (rounded to the neares ten dozen) are as follows: Dozens of Products Relative Demanded Frequency ---------------- --------------- 110 5 120 20 130 25 140 30 150 20 Igam wants to compare two ordering rules for ordering products: 1. order last week's demand plus 10 dozen extra (as safety stock), 2. order 130 dozen every week. He wants to run an eight week simulation to compare the average weekly profit for the two rules. Last week's demand was for 110 dozen. He generated the following random numbers for weeks 1-8, respectively: 63,13,67,50,71,25,44 and 00. a. What is the random number range corresponding to each of the five demand quantities? b. Simulate eight weeks of operation using each of the ordering rules and compute the average weekly profit resulting from each rule. Create a spreadsheet model in Excel for the above problem. Rerun the model for 100 weeks of operation and 500 weeks of operation (trials) using random numbers you generate, rather than the random numbers supplied above. Compare the average weekly profit for the 8 week simulation, 100-week simulation and 500-we
$30 USD 1 päivässä
4,8 (73 arvostelua)
5,9
5,9

Tietoja asiakkaasta

Maan UNITED STATES lippu
Buffalo, United States
0,0
0
Liittynyt marrask. 24, 2018

Asiakkaan vahvistus

Muita töitä tältä asiakkaalta

Help me open a protected workbook -- 2
$10-30 USD
Kiitos! Olemme lähettäneet sinulle sähköpostitse linkin, jolla voit lunastaa ilmaisen krediittisi.
Jotain meni pieleen lähetettäessä sähköpostiasi. Yritä uudelleen.
Rekisteröitynyttä käyttäjää Ilmoitettua työtä yhteensä
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ladataan esikatselua
Lupa myönnetty Geolocation.
Kirjautumisistuntosi on vanhentunut ja sinut on kirjattu ulos. Kirjaudu uudelleen sisään.