mjb08a_E51_RETURNED

# mjb08a_E51_RETURNED - 6 Add a series a Ensure that D2:D3...

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

Budget \$1,200.00 Budget Combinations Qty X Qty Y Brand X Costs \$60.00 If I spend all on X I can buy 20 - Brand Y Costs \$40.00 If I spend all on Y I can buy - 30 - 5 10 15 20 25 - 5 10 15 20 25 30 35 Budget Line Column E Qty Brand X Q t y B r a n d y

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

View Full Document
1. In cell D2 on the perfect tab use a formula to calculate the maximum Qty that can be purchased given the bud g (If we spend all of our budget on X). 2. In cell E2 enter the Qty that can be purchase of Y if we spend all our budgeted money on buying Brand X. 3. In cell E3 use a formula to calculate the maximum Qty that can be purchased given the budget dollar amount a our budget on Y). 4. In cell D3 enter the Qty that can be purchase of X if we spend all our budgeted money on buying Brand Y. 5. Create a graph Scatter Graph, scatter with data points connected with smooth lines. Delete any series that Exce
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 6. Add a series a. Ensure that D2:D3 are the X axis b. Ensure that E2:E3 are the Y axis c. Do not name the series at all - leave it blank 7. Insert a Chart Title, over the chart and make the graph title "Budget Line" 8. Make the Value X axis title below the graph axis say "Qty Brand X" 9. Make the Value Y axis beside the vertical axis of the graph say "Qty Brand Y" 10. Delete the Legend 11. Resize the graph to cell range A4:E13 12. You have \$1200.00 to spend and the price of brand X is \$60.00 and the price of brand y is \$40.00. 13. Input your data to show the correct budget line. Key 9370affde322f57ea133b5ee53f561f4a Student ID 000425711 First Name Matthew Last Name Brown Email [email protected] Assignment E51 Assignment Assignment E51 Excel Activity...
View Full Document

{[ snackBarMessage ]}

### Page1 / 3

mjb08a_E51_RETURNED - 6 Add a series a Ensure that D2:D3...

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

View Full Document
Ask a homework question - tutors are online