Search (Option + Q) hulas Data Review View Automate Help Commer mance L Check Accessibility 15 Show Changes Version History New Comment L M 0 P Q R S U V W 6) Use the WACM/unit to calculate the total number of units needed to achieve Jake's target profit (TOTAL column in the second gray box). THEN, calculate the number of EACH type of product needed to achieve the target profit. Finally, calculate sales revenue associated with this volume for EACH product, and then the sales revenue in total. Check figures: B/E Product #1 =792; B/E Product #2=396 7) Calculate the MOS using June sales as the expected sales (purple box). Calculate the MOS in terms of sales revenue and as a percentage. Also calculate the current operating leverage factor (round to the nearest 2 decimal places) and use it to determine the expected percentage change in operating income stemming from an expected change in sales volume. Check figures: MOS%=38%; Operating leverage factor= 2.67 8) Change name of worksheet to "Original Assumptions". 9) Make sure you have cleaned up your worksheet using the formatting conventions listed above. 10) Go to the "Advising client" worksheet and follow the directions found there. vising client Grading Rubric + pg "revenue" revenues revenue's $ % A K 4 5 6 7 8 9 O R T Y U O P F G H J K L V B Business & Directions Starting file Advising client Grading Rubric + Iculation Mode: Automatic Workbook Statistics IMG_3743.jpg IMG_3742.jpgme - MyDBU X Courses X Content / 23/ C maildbu-my.sharepoint.com/:x:/g/personal/credman4255_dbu_edu/E Excel Copy of 1. CVP Excel project- Jake's - Saved Search (Option Home Insert Draw Page Layout Formulas Data Review pelling E13 Workbook Statistics Check Performance Check Accessib X V fx A B C D E F G H H Product 1: "Launch-it"- a tennis ball thrower that will sell for $10. Product 2: "Treat-time"- an automatic treat dispenser that releases a treat when the dog places his paw on the pedal. The treat dispenser will sell for $30. Costs: Jake has hired an employee to work the trade show booths. The work contract is $1,000 per month plus a commission equal to 10% of revenue. Jake will also spend $500 per month on trade-show entry fees. Jake is purchasing the products from a supplier in Mexico. Launch-its cost $1 each; Treat-times cost $7 each. Shipping and handling on the Launch-its will cost $2 each; Shipping and handling on the Treat-times, which are heavier, will cost $8 each. The shipping and handling costs will be paid by Jake, not the customer. Assume Jake expects to sell 200 Launch-its and 100 Treat-times during his first month of operations (June). Jake's financial goal is to earn an operating income of $8,000 per month. He believes volume may grow at a rate of 5% a month. > Business & Directions Starting file Advising client Grading Rubric + Iculation Mode: Automatic Workbook Statistics IMG_3743.jpg IMG_3742.jpgC maildbu-my.sharepoint.com/:x:/g/personal/credman4255_dbu_edu/E Excel Copy of 1. CVP Excel project- Jake's - Saved Search (Option Home Insert Draw Page Layout Formulas Data Review pelling 3 Workbook Statistics Check Performance La Check Accessi X V fx A B C D E F G H CVP Modeling project The purpose of this project is to give you experience creating a multiproduct profitability analysis that can be used to determine the effects of changing business conditions on the client's financial position. Your goal will be to use Excel in such a way that any changes to the assumptions will correctly ripple through the entire profitability analysis. If executed properly, the client should be able to use this spreadsheet over and over, using different "what if" assumptions. Business Description After taking business classes, Jake, an avid dog-lover, decided to start selling unique pet supplies at trade shows. He has two products: Product 1: "Launch-it"- a tennis ball thrower that will sell for $10. Product 2: "Treat-time"- an automatic treat dispenser that releases a treat when the + dog places his paw on the pedal. The treat dispenser will sell for $30. Costs: Jake has hired an employee to work the trade show booths. The work contract is $1,000 per month plus a commission equal to 10% of revenue. Jake will also spend $500 per month on trade-show entry fees. Jake is purchasing the products from a supplier in Mexico. Launch-its cost $1 each; Treat-times cost $7 each. Shipping and handling on the Launch-its will cost $2 each; Shipping and handling on the Treat-times, which are heavier, will cost $8 each. The shipping and handling costs will be paid by Jake, not the customer. Business & Directions Starting file Advising client Grading Rubric + alculation Mode: Automatic Workbook Statistics IMG_3743.jpg IMG_3742.jpg esc 9 "revenue"C maildbu-my.sharepoint.com/:x:/g/personal/credman4255_dbu_edu/E Excel Copy of 1. CVP Excel project- Jake's - Saved Search (Option Home Insert Draw Page Layout Formulas Data Review pelling 3 Workbook Statistics Check Performance La Check Accessi X V fx A B C D E F G H CVP Modeling project The purpose of this project is to give you experience creating a multiproduct profitability analysis that can be used to determine the effects of changing business conditions on the client's financial position. Your goal will be to use Excel in such a way that any changes to the assumptions will correctly ripple through the entire profitability analysis. If executed properly, the client should be able to use this spreadsheet over and over, using different "what if" assumptions. Business Description After taking business classes, Jake, an avid dog-lover, decided to start selling unique pet supplies at trade shows. He has two products: Product 1: "Launch-it"- a tennis ball thrower that will sell for $10. Product 2: "Treat-time"- an automatic treat dispenser that releases a treat when the + dog places his paw on the pedal. The treat dispenser will sell for $30. Costs: Jake has hired an employee to work the trade show booths. The work contract is $1,000 per month plus a commission equal to 10% of revenue. Jake will also spend $500 per month on trade-show entry fees. Jake is purchasing the products from a supplier in Mexico. Launch-its cost $1 each; Treat-times cost $7 each. Shipping and handling on the Launch-its will cost $2 each; Shipping and handling on the Treat-times, which are heavier, will cost $8 each. The shipping and handling costs will be paid by Jake, not the customer. Business & Directions Starting file Advising client Grading Rubric + alculation Mode: Automatic Workbook Statistics IMG_3743.jpg IMG_3742.jpg esc 9 "revenue"