Question: I need help with formulating the pictured problem in Excel. Pictured below is what I have in Excel so far and Problem 3.10 I also

I need help with formulating the pictured problem in Excel.

Pictured below is what I have in Excel so far and Problem 3.10

I also need help with knowing what formula to input to get the desired output and constraints in Excel Solver for the problem.

I need help with formulating the pictured problem

P CT CU CV CW CX CY CZ DA E F G H K L M N CP CO CR CS A B C D Problem 3.10 (Change making problem) $0.89 $0.90 $0.91 $0.92 $0.93 $0.94 $0.95 $0.96 $0.97 $0.98 $0.99 Average W N Balance $0.00 $0.01 $0.02 $0.03 $0.04 $0.05 $0.06 $0.07 $0.08 $0.09 $0.10 $0.11 99 99 99 99 99 99 99 99 99 99 99 Stage 0 Penalty 0 99 99 99 99 99 99 99 99 99 99 99 Stage 1 Penny OO O LD CO 0 10 0 11 Nickel 0 12 13 Dime 14 15 16 Quarte UNION 17 18 19 20 Min 21 22 Stage 2 Penny O O 23 24 0 25 0 26 27 Nickel HO 28 29 Dime 30 31 32 Quarte 33 34 W N 35 36 MinCU CV CW CY CZ K L M N P CP CQ CR CS CT CX DA DB A B C D E F G H I J 37 38 Stage 3 Penny 39 40 2 41 42 43 Nickel 44 45 Dime 46 47 48 Quarte O 49 50 51 52 Min 53 54 Stage 4 Penny 55 56 57 58 59 Nickel 60 61 Dime 62 ooo 63 64 Quarte 0 65 O 66 O 67 68 Min69 70 Stage 5 Penny 71 72 IN 73 74 75 Nickel 76 77 Dime OOO 78 79 80 Quarte O 81 W N P o o O 82 83 84 Min 85 86 87 88- Problem 3.10* (Change making problem): Dani Hofmann, who is working at a local retail store, is always busy making changes with coins daily. Naturally, he is interested in the average number of coins required that can make any change from 0 to 99 cents. Suppose that there are 1 cent, 5 cent, 10 cent, 20 cent, 25 cent, and 50 cent pieces. Let us assume that the probability of a transaction resulting in value x has a uniform distribution over [0, 99]. (You may use any spreadsheet software or write your own script to answer the following questions.) (2 points of extra-credit) (a) If he uses the most efficient dynamic programming method, what is the average number of coins in a transaction? (b) Suppose that he makes change using four different types of coins: 1C, 5C, 180, and 25C. In such a case, find the average number of coins in a transaction if he uses the most efficient method

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Hi There, I need to fix all of the attached assignments. Budget is $90 in CDN for all. All assignments are due by 1:00 PM. (Vancouver time)on Sunday. Thanks AP1-3 Comparing Net Earnings with Cash...

Assignment Description: Business analytics skills using optimisation methods must be demonstrated in this assignment. You will need to use linear programming to formulate and model a problem, and...

Evaluation and Control in Strategic Management Evaluation and control information consists of performance data and activity reports (gathered in Step 3 in Figure 11-1). If undesired performance...

Hello I have an excel mathematical question and need help formulating a model. Below I have attached the question of the problem and notes and examples all in order that I hope are helpful. I am...

I need help solving all the tabs in this excel i need help solvong all the tabs on this excel File AutoSave Off Financial Accounting Excel Project) Sophia Asht Home Insert Draw Page Layout Formulas...

Hi There, I need someone to help me with the attached finance worksheet. There are 3 problems in this excel file - one problem on each individual tab. I am attaching a couple of additional files as...

pleaseee answer all of thesee and show the formulas Data Window Help WD Thu May 12 3:52 PM Excel File Edit View Insert Format Tools AutoSave AO A my ... Home Insert Draw Page Layout Formulas Data OFF...

Question One: (20 Marks] In chapter 5, you have studied the 4 creative problem-solving steps. You are requested to think about any problem you are currently facing (or you faced in the past) then do...

please answer questions 1-4 to the best of your abilities. please complete a schedule m1 and tax return on form 1120. On form 1120 i need to know the number on line 28 and 30. If info isnt listed...

pleeseeee help me. Question 1 H&H is a Singapore-based tannery that supplies high quality exotic leather to major international fashion houses and customers globally. Tanning is the process of...

estion 39 The minimum numbers of functions need to be presented in c++ progtam is 0? yet vered Select one: ked out of O a. False Flag question O b. True

Parent plc acquired 80% of the share capital of Controlled Ltd on 30 June 20X1. At that date, Controlled Ltd had retained earnings of 1 050 000. Controlled has not issued any additional share capital...

T - Slough Industries employs a standard cost system in which direct materials inventory is carried at standard cost. Jackson has established the following standards for the costs of one unit of...

ncreasingly, laws and policies are being enacted to restrict persons with a felony conviction (particularly convictions for drug offenses) from employment, receipt of welfare benefits, access to...