Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

need help on the spread sheet and the right option to choose Make sure you are using the Baseline Data, and then set the Selling

image text in transcribed

image text in transcribed

need help on the spread sheet and the right option to choose

Make sure you are using the Baseline Data, and then set the Selling Price value to $30.18. What is the Margin that results from this price? OA) 34.1% B) 33.6% C) 34.7% D) 35.3% Hi there! I've been playing with the numbers here, just wondering what would happen. Unfortunately, I've forgotten the original values. :( You saved these somewhere, right!? Man, hope so... Us - Bob Outputs (Results) 2 Inputs (Assumptions) 4 5 Selling Price $ 63.00 / widget 6 Unit Variable Cost $ 19.80 / widget 7 Shipping Cost $ 0.25 /widget 8 Billboard Advertising $ 450 gr 9 Total Fixed Cost 17.500 /qtr 10 11 Target Quantity 2.700 widgets/qtr 12 13 14 15 16 17 18 19 20 21 22 23 24 21 26 27 28 29 30 31 Contribution Per Unit Margin $ 42.95 68.2% Break-Even Per Quarter in Units In $ Sales 418 Quartery Results at Target Sales of 2,700 widgets Revenue 170,100 Variable Cost 54,135 Fixed Cost 17,500 Billbord Ads $ 450 Total Cost $ 72,085 Net Income S 98,015

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_2

Step: 3

blur-text-image_3

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

Modern Internal Auditing An Operational Approach

Authors: Victor Zinn Brink

3rd Edition

0471065242, 978-0471065241

More Books

Students also viewed these Accounting questions

Question

5. Prepare for the role of interviewee

Answered: 1 week ago

Question

6. Secure job interviews and manage them with confidence

Answered: 1 week ago