Qma_part_b 5.18(1)

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

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

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

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

View Full Document
Status Slack Not Binding 620 Binding 0 Binding 0 Not Binding 48
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)

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

View Full Document
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
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

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### 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
Ask a homework question - tutors are online