Question: *****CAN YOU PLEASE PUT THE ANSWER STEP BY STEP IN AN EXCEL FILE I want to know how to do it on an excel spreadsheet

*****CAN YOU PLEASE PUT THE ANSWER STEP BY STEP IN AN EXCEL FILE I want to know how to do it on an excel spreadsheet please******

SamanthaandSabrinaareopeningasodastand. Theybelievethefixedcost per week of running thestand is$50.00.Their best guess isthat theycan sell300 sodas perweekat $0.75 per soda.Thevariable costofobtaining acanofsoda is $0.20.

A. Given herother assumptions, and usingExcel, find thelevelofsales volumethatwill enable them to break even.

B. Given her other assumptions, drawabreak-even graph and discuss howa change in salesvolume affectsprofit.

C. From the graph in (b)discuss how changes insales volume and variable cost jointly affect profit.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

*****CAN YOU PLEASE PUT THE ANSWER STEP BY STEP IN ANEXCEL FILE I want to know how to do it on an excel spreadsheetplease****** 6. The following data were collected on scores (out of a possible 100)...

Read the attached articles and answer the questions below. Please respond in complete sentences and justify your answer when required. Please use your own words. Each answer should be at least one...

*****CAN YOU PLEASE PUT THE ANSWER STEP BY STEP IN AN EXCEL FILE I want to know how to do it on an excel spreadsheet please****** Chad Holmes has been thinking about starting his own independent...

*****CAN YOU PLEASE PUT THE ANSWER STEP BY STEP IN AN EXCEL FILE I want to know how to do it on an excel spreadsheet please****** 6. It is the first day of pheasant season and Frank is getting ready...

*****CAN YOU PLEASE PUT THE ANSWER STEP BY STEP IN AN EXCEL FILE I want to know how to do it on an excel spreadsheet please****** 1. You are given the following data set: 2, 45, 34, 25, 6, 45, 67,...

*****CAN YOU PLEASE PUT THE ANSWER STEP BY STEP IN AN EXCEL FILE I want to know how to do it on an excel spreadsheet please****** You are given the following data set: 5000, 6524, 8524, 7845, 2100,...

*****CAN YOU PLEASE PUT THE ANSWER STEP BY STEP IN AN EXCEL FILE I want to know how to do it on an excel spreadsheet please****** The following are numerical statistics for five data sets. Using...

10. The VA-TX Company has noticed when it advertises, it dramatically increases the amount of customers who buy its product at seminars. With advertising, VA-TX expects the audience to buy the...

please please please help Your company will be a small manufacturing/wholesale business that rents a Business Unit that has both a production and an administration area. The company will make the...

Describe the typical first-day return of an IPO and the long-term returns to IPO investors. Randys, a family-owned restaurant chain operating in Alabama, has grown to the point at which expansion...

Complete the SQL DDL definition of the bank database of Figure to include the relations loan andborrower. create table customer (customer-name char(20), customer-street char(30), customer-city...

SCalc 8 1 5 . 3 . 0 0 8 . Evaluate the given integral by changing to polar coordinates. R ( 4 x y ) dA , where R is the region in the first quadrant enclosed by the circle x 2 + y 2 = 2 5 and the...

The Verbrugge's Publishing Company's 2004 balance sheet and income statement are as follows (in millions of dollars). Verbrugge's and its creditors have agreed upon a voluntary reorganization plan....

Hindi Company has the following production data for April: units transferred out 40,000, and ending work in process 5,000 units that are 100% complete for materials and 40% complete for conversion...

Bad-Debt Reporting Issues Clark Pierce conducts a wholesale merchandising business that sells approximately 5,000 items per month with a total monthly average sales value of $250,000. Its annual bad...

The potential in a region between x = 0 and x = 6.00 m is V = a + bx, where a = 10.0 V and b = -7.00 V/m. Determine (a) The potential at x = 0, 3.00 m, and 6.00 m, and (b) The magnitude and direction...

Arna, Inc. uses the dollar-value LIFO method of computing its inventory. Data for the past 3 years follow. Year Ended December 31 Inventory at Current-year Cost Price Index 2009 $19,750 100 2010...

Design a minimum-mass symmetric three-bar truss (the area of member 1 and that of member 3 are the same) to support a load P, as was shown in Fig. 2.9. The following notation may be used: Pu = P cos...

13.86 Logistic versus linear For binary response variables, one reason that logistic regression is usually preferred over straight-line regression is that a fixed change in x often has a smaller...

13.80 True or false: Slopes For data on y = college GPA, x1 = high school GPA, and x2 = average of mathematics and verbal entrance exam score, we get yn = 2.70 + 0.45x1 for simple regression and yn =...

13.85 Multicollinearity For the high school female athletes data file, regress the maximum bench press on weight and percent body fat. a. Show that the F test is statistically significant at the 0.05...