Detailed Analysis - Show your work/calculations. Mr Muffler Garage is developing an operating budget for the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Detailed Analysis - Show your work/calculations. Mr Muffler Garage is developing an operating budget for the month ending June 30, 2024. They expect to perform 800 repairs and maintenance during the month for high-end luxury cars and will collect 30% of this revenue within this month, the 70% remaining balance will be collected in July. The average charge to customers (price) per repair is $250. The cost of materials used for each of these maintenance activities is $30. Muffler also contracts with quality inspectors that charge $75 per repair. The total annual salaries for Muffler's receptionist, bookkeeper, and two mechanics is combined to equal $126,000. Muffler's occupancy costs, which include space rental is $8,200 per month. Average monthly utilities costs of $1,200 is fixed and was pre-negotiated with the service providers. Office and garage equipment was installed at a cost of $240,000. The equipment is expected to have a 5-year life and has salvage value of $20,000. On June 1, Muffler borrowed $50,000 from the bank at an annual rate of 6% to be repaid in 7 years. Muffler plans to repay the full $50,000 according to the loan terms (see details in (ii) below). (i) Prepare Muffler's operating budget for the month of June 2023 i) Mr Muffler Operating Budget For month ending June 30, 2022 Revenues Expenses Interest Expense Inspection Fees Materials Salaries 250 ($50,000 * 6%)/12 Rent Utilities Depreciation Total Expenses Profit/(Loss) 250 (250) (ii) Now assume the following and prepare a cash budget for the month of June 2023. a. They purchase materials on credit and have 90 days to pay, Muffler takes advantage of these credit terms b. Quality inspectors are paid 50% in the current month and 50% in the following month c. Rent is prepaid (paid in advance) for the full 12 month year, the full payment is made on June 1 of every year d. Utilities are paid monthly and June's utility will be paid on June 30 e. 25% of the equipment installed is due in the current month and the remaining will be payable in Year 7 f. the first month interest payment is due on July 1, 2022 g. on June 1 Muffler had $75,000 in their bank account h. All Muffler employee salaries are paid on June 30 ii) Mr Muffler Beginning Cash Loan Proceeds Cash available Interest Expense Inspection Fees Materials 0 30% of revenue collected Salaries Rent Utilities Office Equipment Cash Disbursements Ending Cash Detailed Analysis - Show your work/calculations. Mr Muffler Garage is developing an operating budget for the month ending June 30, 2024. They expect to perform 800 repairs and maintenance during the month for high-end luxury cars and will collect 30% of this revenue within this month, the 70% remaining balance will be collected in July. The average charge to customers (price) per repair is $250. The cost of materials used for each of these maintenance activities is $30. Muffler also contracts with quality inspectors that charge $75 per repair. The total annual salaries for Muffler's receptionist, bookkeeper, and two mechanics is combined to equal $126,000. Muffler's occupancy costs, which include space rental is $8,200 per month. Average monthly utilities costs of $1,200 is fixed and was pre-negotiated with the service providers. Office and garage equipment was installed at a cost of $240,000. The equipment is expected to have a 5-year life and has salvage value of $20,000. On June 1, Muffler borrowed $50,000 from the bank at an annual rate of 6% to be repaid in 7 years. Muffler plans to repay the full $50,000 according to the loan terms (see details in (ii) below). (i) Prepare Muffler's operating budget for the month of June 2023 i) Mr Muffler Operating Budget For month ending June 30, 2022 Revenues Expenses Interest Expense Inspection Fees Materials Salaries 250 ($50,000 * 6%)/12 Rent Utilities Depreciation Total Expenses Profit/(Loss) 250 (250) (ii) Now assume the following and prepare a cash budget for the month of June 2023. a. They purchase materials on credit and have 90 days to pay, Muffler takes advantage of these credit terms b. Quality inspectors are paid 50% in the current month and 50% in the following month c. Rent is prepaid (paid in advance) for the full 12 month year, the full payment is made on June 1 of every year d. Utilities are paid monthly and June's utility will be paid on June 30 e. 25% of the equipment installed is due in the current month and the remaining will be payable in Year 7 f. the first month interest payment is due on July 1, 2022 g. on June 1 Muffler had $75,000 in their bank account h. All Muffler employee salaries are paid on June 30 ii) Mr Muffler Beginning Cash Loan Proceeds Cash available Interest Expense Inspection Fees Materials 0 30% of revenue collected Salaries Rent Utilities Office Equipment Cash Disbursements Ending Cash
Expert Answer:
Related Book For
Financial Management For Public Health And Not-for-Profit Organizations
ISBN: 9781071835333
7th Edition
Authors: Steven A. Finkler, Daniel L. Smith, Thad D. Calabrese, Robert M. Purtell
Posted Date:
Students also viewed these accounting questions
-
Considere el espectrmetro de masas que se muestra esquemticamente en la fi gura 29.13. La magnitud del campo elctrico entre las placas del selector de velocidad es 2 500 V/m, y el campo magntico...
-
Monroe Outpatient Surgery Center (MOSC) is developing an operating budget for the month ending June 30, 2024. MOSC expects to perform 80 surgical procedures during the month. MOSCs average charge...
-
Monroe Outpatient Surgery Center (MOSC) is developing an operating budget for the month ending June 30, 2014. The Center expects to perform 80 surgical procedures during the month. MOSCs average...
-
Marc & Kent operate a vineyard as partners. The partnership trades under the business name Victor Estate. Victor Estate has prepared a general ledger for the 2023 income year showing the following...
-
Gotham Company purchased a new machine on October 1, 2017, at a cost of $90,000. The company estimated that the machine has a salvage value of $8,000. The machine is expected to be used for 70,000...
-
Write each number as a decimal. 4.112 * 10 2
-
On January 1, 2013, three individuals organized West Company as a corporation. Each individual invested \(\$ 10,000\) cash in the business. On December 31, 2013, they prepared a list of resources...
-
Hawthorn Corporations adjusted trial balance contained the following accounts at December 31, 2012: Retained Earnings $120,000; Common Stock $750,000; Bonds Payable $100,000; Paid-in Capital in...
-
3. Emma is a 34-year old unmarried accountant with no dependets. She is employed by a small company with 45 employees. Emma is a very ambitious employee with high prospects for the future. Her...
-
End A of the slender pole is given a velocity v A to the right along the horizontal surface. Show that the magnitude of the velocity of end B equals v A when the midpoint M of the pole comes in...
-
The following information was extracted from the records of Violet Limited: 1. A new machine was purchased at a cost of $57202. 2. Proceeds from sale of an existing machine is $110631. This machine...
-
A shark which is a fish and a Cetacea (dolphin and porpoise)which is a mammal. Both species have evolved to live in anaquatic environment. However, if you look closely at theirtails, there is a...
-
Part A An 8.0-m-diameter, 25-m-long cylindrical spaceship needs to have an internal magnetic field with the same strength as earth's. A clever astronaut suggests wrapping the spaceship tightly with...
-
You are David the finance director of the company. David: Finally I'm done with the review. Ah.. Linda what is the matter? Linda: David, I would like to report that one of our major customers super...
-
These are financial ratios of blockbuster for the year 2006 and 2010. Based on each of these these ratios, compare and comment the financial situation of the company. Computation of Financial ratios:...
-
How do we determine the value of works of art? Is there something intrinsic to the work that determines the price? Is it simply a matter of what the market will bear?...
-
Super Cool Inc, manufactures cooling units for commercial buildings. The price and cost of goods sold for each unit are as follows: Price 40,500 per unit Cost of goods sold 25,500 Gross Profit 1...
-
The following information is for Montreal Gloves Inc. for the year 2020: Manufacturing costs Number of gloves manufactured Beginning inventory $ 3,016,700 311,000 pairs 0 pairs Sales in 2020 were...
-
Suppose Searing School District provides paid time off (PTO) to its employees, and unused PTO may be transferred to the next fiscal year. During the year, employees earned $100,000 of PTO and carried...
-
Discuss how having a flexible budget would have been useful for governmental, health, and not-for profit organizations when the COVID pandemic hit the United States in 2020.
-
Should the accounts receivable reported on the balance sheet match the revenues less any amount collected during the current year?
-
Lessee Company enters into a 6-year finance lease of non-specialized equipment with Lessor Company on January 1,2020 . Lessee has agreed to pay \(\$ 28,000\) annually beginning immediately on January...
-
Frontier Inc. enters into an 8 -year lease contract to lease equipment with a useful life of 8 years. Annual lease payments are due with the first payment made immediately on January 1, 2020, the...
-
Referring to the information in Brief Exercise 17-28, assume the same information except that the lessee guaranteed the residual value for \(\$ 5,000\) at the end of the lease term. Compute the value...
Study smarter with the SolutionInn App