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

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
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
Background image of page 2
Background image of page 3
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 mjb08a@acu.edu Assignment E51 Assignment Assignment E51 Excel Activity...
View Full Document

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 Right Arrow Icon
Ask a homework question - tutors are online