Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Ese For the following questions, refer to spreadsheet titled Section D illy owns a bicycle shop that sells one of a kind lightweight, folding bikes.

image text in transcribed
Ese For the following questions, refer to spreadsheet titled "Section D illy owns a bicycle shop that sells one of a kind lightweight, folding bikes. The sh op pays $12,000 a month in rent and spends $3,000 for utilities. The materials to make the bike are $275 and labor is $75 per bike. Benny then sells each bike for $600. Using this information, fill in the Excel spreadsheet and answer the following questions (5pts) 1. 2. 3. 4. 5. What is the formula for break-even analysis? What is the total fixed cost? What is the total variable cost? How many bikes does Benny need to sell to breakeven? What will be the new breakeven if rent increases by $1,000 a month? BONUS QUESTION (You must answer all previous questions to qualify for bonus points) Amr's Taco Truck sells only two items: Tacos for $4.5 and Soda for $2.5. Tacos account for 75% of total revenue and sodas account for 25%. The fixed cost to operate the truck each day is $400. Below you will find the variable costs for each item (2 bonus points). Wages Ingredients Tacos $2.0 $1.5 Lemonade $0.25 $0.25 How many tacos and sodas does Amr need to sell to break-even? Show your work on the back of the answer sheet. a

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

Financial And Managerial Accounting Vol 1

Authors: John Wild, Ken Shaw, Barbara Chiappetta

4th Edition

0077318358, 978-0077318352

More Books

Students also viewed these Accounting questions

Question

Question Can plan participants borrow from a VEBA?

Answered: 1 week ago