Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Olympic Wash 15 a high end car wash service based m northern Illinois. Being one of the most popular car washes in the arca,
Olympic Wash 15 a high end car wash service based m northern Illinois. Being one of the most popular car washes in the arca, they are known for their outstanding service and immaculate car washes. Olympic Wash is owned by Bob Nelson, a young entrepreneur who has had experience working in his family car repair business for over 10 years. Having owned a car repair shop in the same part of town, the Nelson family is well known and respected which helps Bob bring in many of their car repair customers for car washes. Bob, who oversees the entire operation, also handles sales and marketing and works to prepare the 2013 budget with his company controller Christy Smith. The one thing that Olympic strives for is to offer quality car washes that fully satisfy their customers. They offer three different types of car washes: Bronze for $8, Silver for $12, and Gold for $21. Each wash includes different services. Bronze includes just a car wash with the necessary soaps. Silver includes a car wash with the necessary soaps and a special coating is added to the car to give it extra shine. Lastly, Gold entails everything Silver has and also comes with a full vacuuming and detailing of the inside of the car as well. Bob has established his business as a prominent staple in the community and has seen a large amount of sales over the last couple years. Christy reported that the sales for 2012 were 9,400 washes of Bronze, 8,000 washes of Silver, and 6,700 of Gold. Bob also values customer satisfaction, as he feel that his business and community reputation and repeat business are the reasons that he has been so successful in the past. After every car wash each customer is given a card and is encouraged to respond to the short customer satisfaction survey about the service they received. Bob strives to maintain at least a 94% customer satisfaction rating and at the end of every year rewards his employees with a $100 bonus for ever percentage above 94% in D'Focus When debating over what the 2013 budget should look like Christy was adamant that through advertising they could raise their sales in all categories of washes. Bob estimated that with extra encouragement when customers came in that they could entice customers to go with the Silver or Gold wash instead of choosing Bronze. They came to the conclusion that through a 10% increase in advertisement (PY $2,300) and encouragement they would see a growth in Silver by 15% and growth in Gold by 10%, with decrease of 10% in Bronze. With this increase in sales and time it takes to perform the higher level car washes, they figured they would have to hire an additional employee to help assist in the washing Some facts to consider for 2021: * Salary and bonuses for the Bob and Christy are set at a combined $95,000 plus a 5% bonus on any profit made. Discounts are calculated at 2% of gross sales. Direct material costs for per wash for 2012 for Bronze washes $2, Silver = $3, and Gold =$5. For 2013 they anticipate that Direct Material costs per wash will remain the same. Car wash employees have wages of $8/hour plus any tips received. There are currently 6 car wash employees in which it is anticipated that each employee will work for a total of 2,000 hours a year (40 hour weeks with one week of vacation and one week of sick time unpaid). After every 100 car washes hose valves have to be changed. These valves cost $8 to replace. Anticinatino a customer satisfaction ratino of 96% Direct material costs for per wash for 2012 for Bronze washes = $2, Silver = $3, and Gold =$5. For 2013 they anticipate that Direct Material costs per wash will remain the %3D same. Car wash employees have wages of $8/hour plus any tips received. There are currently 6 car wash employees in which it is anticipated that each employee will work for a total of 2,000 hours a year (40 hour weeks with one week of vacation and one week of sick time unpaid). - After every 100 car washes hose valves have to be changed. These valves cost $8 to replace. * Anticipating a customer satisfaction rating of 96%. o Yearly rent = $10,000 Insurance Premium = $3,000 Depreciation = $3,000 Miscellaneous Expenses = $1,600 Utilities Expense = $3,400 Other Operating Expense = 2% of Gross Sales Your job is to assist Bob and Christy in preparing the operating budget for 2013. Budget 2021 Sales Budget Worksheet: 9 Unit Count (Washes) Bronze Silver Gold Budget Totals 10 Gross Sales 11 (Less) Discounts-Coupons 12 Net Sales 13 Materials 14 Labor 15 Values 16 Other Oper Expenses Total Units (2012) Budget Increase (decrease) Budget-2013 Average Price Budget Gross Sales by Type Less-Ave. Discount-Coupons Budget Net Sales by Type Net Ave. Price 17 Gross Profit 18 Advertising 19 Rent 20 Insurance 21 Depreciation 22 Miscellaneous 25 Utilities (Non-Operating) 24 Salaries Mngmt Cost Budget Worksheet: Material Other Operating Expenses Advertising (PY 2,900) Valves Total Expenses Labor: Number of Employees 25 26 Profit before Bonus 27 Management Bonus 28 Employee Bonus 29 Profit Number of Hours, Each Total Hours Rate Total Labor Cost 30
Step by Step Solution
There are 3 Steps involved in it
Step: 1
C 2020 Budget Case Worksheet Olympic Wash A OPERATING BUDGET 2013 Sales Budget Worksheet Budget 2013 ...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