Qma_part_b 5.18(1) - Microsoft Excel 11.0 Answer Report...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
Microsoft Excel 11.0 Answer Report Worksheet: [Qma_part_b 5.18.xls]Sheet1 Report Created: 2008-5-18 12:18:25 Target Cell (Max) Cell Name Original Value Final Value $B$82 Profit Product 1 Rolls (q1) 37 133 Adjustable Cells Cell Name Original Value Final Value $B$72 Product 1 Rolls (q1) 200 800 $C$72 Product 2 Loaves (q2) 15 10 Constraints Cell Name Cell Value Formula $B$74 qa>=180 Product 1 Rolls (q1) 800 $B$74>=$C$74 $B$75 Product 1 Rolls (q1) 10 $B$75>=$C$75 $B$76 Max Labour (min)=480 Product 1 Rolls (q1) 480 $B$76<=$C$76 $B$77 Product 1 Rolls (q1) 92 $B$77<=$C$77
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Status Slack Not Binding 620 Binding 0 Binding 0 Not Binding 48
Background image of page 2
Table 1 Labour per item (mins) 0.5 8 Flour per item (kgs) 0.1 1.2 Price ($) 0.4 3.5 Table 2 Item Value Cost of Labour ($ per hour) 10.5 Cost of Flours ($ per Kg) 1.5 Days open per week (Days) 5 Weeks open per year (weeks) 35 Rent ($ per week) 650 Utilites cost ($ per week) 23 Table 3 Item # Req Cost/Item Kneeding Machine 2 $3,850 Baking Oven 3 $11,000 Rolls (q1) Loaves (q2) 800 10 Table 4 Constraints Value Max Kg for rolls and loaves 92 140 Max labour (Hr) 8 8 Min Rolls productions 800 180 Min Loaves productions 10 10 Marginal Cost (MC1) (Rolls) 0.24 Marginal Cost (MC2) (Loaves) 3.2 Maximum Bread Profit per day 133 Product 1 Rolls (q1) Product 2 Loaves (q2)
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Real Net Profit per day $(16.43) Table 5: Operations Days 5 / Week Week 35 / Year Days operate 175 / Year Table 6: Costs Summary Fixed Costs Costs Amount Rent 650 /week 6500 /year Utilities 23 /week 230 /year Total fixed costs 6730 /year Weekly depreciate rate 0 Week Deposit Fund Interest 1 $74 $- $74 $74 2 $74 $0.17 $74.30 $148 3 $74 $0.34 $74.47 $223 4 $74 $0.51 $74.64 $298 5 $74 $0.68 $74.81 $372 ….. 345 $74 $88.59 $162.72 $38,881 346 $74 $88.96 $163.09 $39,044 347 $74 $89.34 $163.47 $39,207 348 $74 $89.71 $163.84 $39,371 349 $74 $90.08 $164.22 $39,535 350 $74 $90.46 $164.59 $39,700 FC per day $149.43 Yearly Depreciation Total Depreciation
Background image of page 4
Week Deposit 1 $74 $- $74 $74 2 $74 $0.17 $74.30 $148 3 $74 $0.34 $74.47 $223 4 $74 $0.51 $74.64 $298 5 $74 $0.68 $74.81 $372 6 $74 $0.85 $74.98 $447 7 $74 $1.02 $75.16 $522 8 $74 $1.20 $75.33 $598 9 $74 $1.37 $75.50 $673 10 $74 $1.54 $75.67 $749 11 $74 $1.71 $75.85 $825 12 $74 $1.89 $76.02 $901 13 $74 $2.06 $76.19 $977 14 $74 $2.24 $76.37 $1,053 15 $74 $2.41 $76.54 $1,130 16 $74 $2.59 $76.72 $1,207 17 $74 $2.76 $76.89 $1,284 18 $74 $2.94 $77.07 $1,361 19 $74 $3.11 $77.24 $1,438 20 $74 $3.29 $77.42 $1,515 21 $74 $3.47 $77.60 $1,593 22 $74 $3.64 $77.78 $1,671 23 $74 $3.82 $77.95 $1,749 24 $74 $4.00 $78.13 $1,827 25 $74 $4.18 $78.31 $1,905 26 $74 $4.36 $78.49 $1,984 27 $74 $4.54 $78.67 $2,062 28 $74 $4.72 $78.85 $2,141 29 $74 $4.90 $79.03 $2,220 30 $74 $5.08 $79.21 $2,299 31 $74 $5.26 $79.39 $2,379 32 $74 $5.44 $79.57 $2,458 33 $74 $5.62 $79.76 $2,538 34 $74 $5.81 $79.94 $2,618 35 $74 $5.99 $80.12 $2,698 36 $74 $6.17 $80.30 $2,778 37 $74 $6.36 $80.49 $2,859 38 $74 $6.54 $80.67 $2,940 39 $74 $6.73 $80.86 $3,020 40 $74 $6.91 $81.04 $3,101
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/12/2010 for the course ECON 1201 at University of New South Wales.

Page1 / 23

Qma_part_b 5.18(1) - Microsoft Excel 11.0 Answer Report...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online