Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The steps you will follow for this project are as follows: 1) Review the video and/or the scripted PDF's for Windows or Mac. 2) Download

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
The steps you will follow for this project are as follows: 1) Review the video and/or the scripted PDF's for Windows or Mac. 2) Download the Excel data file. (After you download the file, YOU NEED TO "SAVE" YOUR ASSIGNMENT BY CLICKING THE SAVE BUTTON IN THE UPPER RIGHT HAND CORNER BEFORE YOU EXIT. If you do not save your assignment, the next time you enter, you may see a different company and set of data.) 3) Perform the requirements on the data file using the video or pdf's. 4) Check your work in the Excel file with these check figures. 5) Use your Excel file to answer the six multiple choice questions below. (You will have to scroll down to see all of the questions.) Resources A) Information on how to update Excel and Office 365. B) If you do not have Office 365, click here to learn how to get it for free. C) Information on data column headings. D) Information on data table descriptions. E) Troubleshooting FAQ. This project only has one attempt. Review the check figures with your data file results before answering the questions. If your check figures do not match, do not proceed with answering the questions until you have asked for assistance from your instructor. Using the pivot table you created for Requirement 2 in Strong Insurance, what was the variable cost of the life insurance policy sold by Harry on 1/21/2017? O A. $212.92 O B. $59.45 O C. $26.32 O D. $239.24Using the pivot table you created for Requirement 3 in Strong Insurance, what was the sum of variable cost for disability insurance sales? A. $6,166,219.14 $4,127,560.09 $1,882,450.40 $1,874,019.83 53.0!\" Using the pivot table you created for Requirement 3 in Strong Insurance, what was the average of the contribution margin for home insurance sales? C22 A. $6,298,304.16 $342.46 $492.44 $8,172,323.99 p.096 Using the pivot table you created for Requirement 4 in Strong Insurance, which insurance type had the highest contribution margin ratio? 5:} A. Professional Life B "'j} C. Home D Disability E . Auto Using the pivot table you created for Requirement 5 in Strong Insurance, what was the sum of the contribution margin ratio for Pennsylvania? if} A. 78.71% 73.02% 69.98% PP!\" 71.32% Using the pivot table you created for Requirement 6 in Strong Insurance, what was the sum of the contribution margin ratio for the North Coast region? A. 71.32% 70.53% 71.42% 9.097 71.16% Check Figures Requirement 1: Cell 3? Requirement 2: Cell J25 Requirement 3: Cell F7 Requirement 4: Cell 36 Requirement 5: Cell 323 Requirement 6: Cell B15 $3,285,870.83 $230.08 $338.00 78.32% 72.17% 74.10%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Consolations Of Economics How We Will All Benefit From The New World Order

Authors: Gerard Lyons

1st Edition

0571307795, 9780571307791

More Books

Students also viewed these Accounting questions