Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 23, 2024

calculate the break even analysis in excel sheet according to the assumptions below. unit sale price= $15 variable cost per unit= $4 payroll= $152 bussinesd

calculate the break even analysis in excel sheet according to the assumptions below.

unit sale price= $15

variable cost per unit= $4

payroll= $152

bussinesd lease=80,000

property tax=$ 6,400( 8%)

insurance=$ 20,000

utilities=$8,000

equipment=$15,000

Total annual fix=$129,552

thank you

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

Step: 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

Bookkeeping Management Understand And Manage From Financial Statements No Accounting Knowledge Necessary

Authors: Ed Wuensche

1st Edition

0692951997, 978-0692951996

More Books

Students also viewed these Accounting questions

Question

★★★★★

(a) Starting with solid sucrose, C12H22O11, describe how you would prepare 250 mL of a 0.250 M sucrose solution. (b) Describe how you would prepare 350.0 mL of 0.100 M C12H22O11 starting with 3.00 L...

Answered: 1 week ago

Question

★★★★★

I need help with this. Please do this in excel, and please show the formulas as well. The current risk free rate is 2 percent and the market nsk premium is 4 percent. You are trying to value ABC...

Answered: 1 week ago

Question

★★★★★

15.58 The manager of an automobile repair shop is looking for a car battery that may troubleshoot the factors that shorten a cars battery lifetime and ensure a longer battery life. Three car battery...

Answered: 1 week ago

Question

★★★★★

Indicate whether each of the following is true or false. If an answer is false, explain why. ______ 1. Insolvency means that a debtor has more current liabilities than current assets. ______ 2....

Answered: 1 week ago

Question

★★★★★

calculate the break even analysis in excel sheet according to the assumptions below. unit sale price= $15 variable cost per unit= $4 payroll= $152 bussinesd lease=80,000 property tax=$ 6,400( 8%)...

Answered: 1 week ago

Question

★★★★★

Quantitative Methods 1 Assignment 2 For Full marks you must show detailed calculations for your answers. Question 1: Compute the mean hourly wage paid to carpenters who earned the following wages:...

Answered: 1 week ago

Question

★★★★★

5. Philosophers and scientists alike would argue that humans have: Only hedonic goals and purposes Only eudaimonic goals and purposes Neither hedonic nor eudaimonic goals and purposes A mixture of...

Answered: 1 week ago

Question

★★★★★

Mike was the policy owner and life insured of a 20-year term life insurance policy, with a $500,000 face value, on which he had named his spouse, Rachel, as the beneficiary. Unfortunately, Mike was...

Answered: 1 week ago

Question

★★★★★

sheridan co issued 700,000 of 5-year,6% bonds at 96 on Jan 1 2027. the bonds pay interest annually. compute the total cost of borrowing for these bonds compute the total cost of borrowing for these...

Answered: 1 week ago

Question

★★★★★

Endor Company begins the year with $180,000 of goods in inventory. At year-end, the amount in inventory has increased to $197,000. Cost of goods sold for the year is $1,300,000. Compute Endor's...

Answered: 1 week ago

Question

★★★★★

The Finishing Department of the Maherajah Competition Water Ski Company has the following production and cost data for May 2022: 1. Transferred out: 2,155 water skis. 2. Ending work in process: 625...

Answered: 1 week ago

Question

★★★★★

1. Using any source possible (magazines, journals, personal conversation with a trainer), find a description of a training program. Consider the learning process and the implications of the learning...

Answered: 1 week ago

Question

★★★★★

8. How does practice help learning? What could a trainer do in a training session to ensure that trainees engage in metacognition?

Answered: 1 week ago

Question

★★★★★

2. You are the training director of a hotel chain, Noe Suites. Each Noe Suites hotel has 100 to 150 rooms, a small indoor pool, and a restaurant. Hotels are strategically located near exit ramps of...

Answered: 1 week ago

Previous Question Next Question