I subscribed to your website to get solution urgently for case study .. I found the question before subscribtion , unfortinately after subscribtion I could not found case full solution

Question: El Conejo Auto Clinic (A) Alex Yianna, Administrator of El Conejo Auto Clinic,

your support is required within 1 day please .

El Conejo Auto Clinic El Conejo Auto Clinic had been formed over five years ago. Initially its only line of business was muffler replacements. As the quality of original equipment mufflers improved, and as Mr. Yianna realized that its customers were interested in more than just muffler replacements, the company expanded its product lines. Currently, the company offered four services (or "jobs," as they frequently were called): muffler replacement, tuneup, brake replacement, and lube and oil change. Operation and financial data of the clinic is presented in the attachment. Requirement: 1. Prepare a budget according to the specifications provided in the attached document. 2. Assuming the board has directed Mr. Yianna to revise the budget to produce a profit of $200,000 before taxes, what options does he have to effect the required changes? Which options seem the easiest to implement? 3. After studying the actual results (attached), prepare a fixable budget. 4. Calculate the volume and price variances and suggest reasons behind them Try to set up a spreadsheet to calculate the budget. Make it as formula-driven as possible. This will allow you to easily test assumptions in answering Question 2 and flexible budget. Best wishes.. HBSP Product Number TCGOSI THE CRIMSON PRESS CURRICULUM CENTER THE CRIMSON GROUP, INC. El Conejo Auto Clinic (A) Alex Yianna, Administrator of El Conejo Auto Clinic, was in the process of preparing his budget for the upcoming fiscal year. He had obtained a great deal of information from his supervisory staff and now it was up to him and his staff assistant to put the information together in a format that could be presented to the company's board of directors BACKGROUND El Conejo Auto Clinic had been formed over five years ago. Initially its only line of business was muffler replacements. As the quality of original equipment mufflers improved, and as Mr. Yianna realized that the company's customers were interested in more than just muffler replacements, El Conejo expanded its product lines. Currently, the company offered four services (or "jobs, as they frequently were called): muffler replacement, tune-up, brake replacement, and lube and oil change. A distinctive feature of the clinic was its use of mechanic assistants. Since much of the work traditionally done by mechanics did not require the skill of a trained mechanic, Mr. Yianna realized that he could offer lower prices to his customers by having mechanics only perform those tasks that required their specialized skills. The remaining tasks were done by lower skilled, and hence lower wage, mechanic assistants. Another distinctive feature of the clinic was its testing function. Mr. Yianna had purchased some highly sophisticated equipment that allowed him to test the work of every job to make sure that there were no defects, The equipment that tested muffler replacement, for example, assessed the quality of the seals between the muffler and tailpipes to make sure that they would not rupture after only a few hundred miles of driving Similarly, other equipment tested the timing of an engine following a tune-up. FINANCIAL INFORMATION Mechanics earned $30 per hour mechanic assistants camed SIS per hour. Both figures included fringe benefits. For ease of computation, supplies were classified into units. Each job required a different number of units, and the units for different types of job cost different amounts cach. For example, a supply unit for the Muffler Replacement job cost $25, whereas supply units for Tune-ups and Brake replacements were only SIO each. Fora Lube and Oil Change the supply unit cost was $2.50. Testing was somewhat simpler, since each test cost an average of $15. Exhibit shows the supervisors collective projections for the annual volume for each of the clinic's four jobs. It also shows, for each job, the budgeted price, minutes needed by mechanics and mechanic assistants, and the number of supply units and tests needed. The clinic also had fixed expenses of $280.000 none of which could be attributed to specific jobs. With this information in hand, Mr. Yianna felt he was ready to prepare the first cut at the budget. He asked his staff assistant, Athena Marco, to prepare a separate budget for each job, as well as for the clinic overall, and to calculate the contribution to fixed costs provided by each job the elective This was prepared by PewDid Youngsted as a basis for d iscu sses or ineffective handling of an administrative state Copyright 2017 by David W. Young and The Crimson Group Inc. Toder copies or request permis The C hess Curcu C 6 17- 7. ( e) 617-576 o reproduce this produced , dis my form or by any means without with powe r Them e Group If you believe that you have an illegal copy of this document, please notify the Crime Press Cumiculum Center of this fact Und P ardu 1777 EL CONEJO AUTO CLINIC (A) Exhibit 1. Budget Data Anticipated number of jobs Muffler replacement Tune-up Brake replacement Lube and oil change 3.000 2.000 1.000 500 $200 Price per job Muffler replacement Tune-up Brake replacement Lube and oil change S100 S150 $40 Mechanic minutes per job Muffler replacement Tune-up Brake replacement Lube and oil change Mechanic assistant minutes per job Muffler replacement Tune-up Brake replacement Lube and oil change Supply units per job Muffler replacement Tune-up Brake replacement Lube and oil change Number of Tests per job Muffler replacement Tune-up Brake replacement Lube and oil change H ome Clays/Alcow is only by Muhammad Kawai, King AbouwersytO200 Copying or posting is an interest Pem b aharvard.edur 177807080 EL CONEJO AUTO CLINIC B Exhibit 2. Actual Results Murter Replacement Brake Lube and Tune-Up Replacement On Change Overall Budget Total OD 600 Number of jobs Price per job Total revenue $20000 $450,000 ALD 9000 $162.000 16000 SIXO 5000 568 OGO SHIR.000 Variable expenses per job Total variable expenses $100 $42.000 $110.00 S198,000 $200 $185.200 $2750 6.750 2350 Contribution Totalfixed expenses $27,800 $36,000) (557200) $21.250 56430 Profit 5144350) Variable Expense Detail Mechanics Average of minutes per job Average wape per minute Tocal expense per job 90 60 $12.00 S300 56.00 30 Mechanic Assistants Average of minutes per job Average wage per minute Total expense perjob $0.30 $12.00 5030 99.00 5030 5750 030 SL50 Sugges Average of units per job Average expense per unit Total expense per job $21.00 SO $10.00 550.00 SIS.OD SI3500 $5.00 53000 Testing Average of tests per Average expense per test Total expense per job $1600 SNO $16.00 SER 00 $16.00 S1600 0.00 Total variable expense per job SI00 $110.00 523150 $2750 DO w use only by Mohammad Permission A 2 17700700 00 Congo harvard du