Find Jobs
Hire Freelancers

Spreadsheet model for a small business problem

$25-55 USD

Completed
Posted over 5 years ago

$25-55 USD

Paid on delivery
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?
Project ID: 18339856

About the project

2 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User 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 in 1 day
4.6 (3 reviews)
2.3
2.3
2 freelancers are bidding on average $28 USD for this job
User 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 in 1 day
4.8 (73 reviews)
5.9
5.9

About the client

Flag of UNITED STATES
Buffalo, United States
0.0
0
Member since Nov 24, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.