ISYS_363_-_Excel_Self_Assessment_Problems_-_Fall_2010[1]

ISYS_363_-_Excel_Self_Assessment_Problems_-_Fall_2010[1] -...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
ISYS 363 – Self Assessment Problems Prior Homework Questions from ISYS 263 Problem One The purchase of a car usually entails extensive bargaining between the dealer and the consumer. The dealer has an asking price but typically settles for less. The commission paid to a salesperson depends on how close the selling price is to the asking price. Moe’s Miracle Motors has the following compensation policy for its sales staff. A 5.00 % commission on the actual selling price for cars sold at 95% or more of the asking price. A 2.50 % commission on the actual selling price for cars sold at 90% or more (but less than 95%) of the asking price. A 1% commission on the actual selling price for cars sold less than 90% of the asking price. The dealer will not sell for less than 85% of sales price. The dealer’s price is based on the dealer’s cost plus a 25.00 % markup; for example the asking price on a car that cost the dealer $20,000 would be $25,000. Develop a worksheet to be used by the dealer, which shows his profit (the selling price minus the salesperson’s commission and dealers cost) on every sale. The worksheet should be completely flexible and allow the dealer to vary the markup or commission percentages without having to edit or recopy any of the formulas. You should be able to enter in the prices for three different vehicles at a time.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Problem Two Your parents have agreed to help pay your expenses during the Spring 2011 semester so you can concentrate on your schoolwork after they saw your final grade in ISYS 363. They have asked you to devise a budget so that they make sure that you will make it through the semester. They will check it at the end of each month.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 6

ISYS_363_-_Excel_Self_Assessment_Problems_-_Fall_2010[1] -...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online