Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Directions: You are a small business consultant. Calculate the monthly budget in the Blank_Budget Spreadsheet for the companies below and decide if they can afford

image text in transcribed
image text in transcribed
Directions: You are a small business consultant. Calculate the monthly budget in the Blank_Budget Spreadsheet for the companies below and decide if they can afford needed supplies. Please be sure to distinguish between fixed and variable costs. In addition, add 3 other items that the business might need to balance the budget. Keri, the owner of Sage Car Wash wants to purchase 3 industrial vacuums to clean the carpet of the vehicles serviced. These items have a total cost of $500. Income=$7200 Expenses: Rent=$2300 The total of her expenses comes out to $6,780, I she was to buy the vacuums. it would come out to $7,280. Therefore she would not have enough, I would recommend Internet =$150 to maybe find a better way to advertise, because she is not profiling either way. Water=$2900 Insurance=$330 Soap=$100 Towels=$200 Windex=$175 Tire Cleaner=$175 Miscellaneous=$150 Advertising=$300 Elliot, the owner of Mountain Dog Walkers, wants to purchase a computer system to keep the records of his clients' services. The total cost of the computer system is $2300. Income=$6500 Expenses: Rent=$1000 Internet =$150 Insurance=$50 The total cost of her expenses come out to $3,630, I she was to buy the computer system it would jump up to $5,930, therefore she Brushes=$200 would have enough. I wouldn't recommend her to change anything. Poop Bags=$400 Poop Scooper=$200 Leashes=$150 Dog Snacks=$225 Bowls=$215 Miscellaneous=$50 Advertising=$350 Gas for Vehicle=$640

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

Essentials Of Mis

Authors: Kenneth Laudon

8th Edition

1292153776, 9781292153773

More Books

Students also viewed these Economics questions

Question

An improvement in the exchange of information in negotiations.

Answered: 1 week ago

Question

1. Effort is important.

Answered: 1 week ago