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
-
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...
-
Thieu Co. has delivery equipment that cost $50,000 and has been depreciated $24,000. Instructions Record entries for the disposal under the following assumptions. (a) It was scrapped as having no...
-
In 1995 an anonymous private collector purchased a painting by Picasso entitled Angel Fernandez de Soto for $29,152,000. The picture depicts Picasso's friend deSoto seated in a Barcelona cafe...
-
Suppose your name is Grant Scheffer, and Advanced Automotive repaired your car. You settled the bill as noted on the following invoice. To you this is a purchase invoice. To Advanced Automotive, it...
-
Analyzing and Interpreting Return on Assets Tiffany & Co. is one of the worlds premier jewelers and a designer of other fine gifts and housewares. Presented here are selected income statement and...
-
The Covid-19 pandemic and economic inflation have affected the collection of accounts receivables of many companies. Select a company that you are interested in investigating. Extract its most recent...
-
Table B. 4 presents data for 27 houses sold in Erie, Pennsylvania. a. Fit a simple linear regression model relating selling price of the house to the current taxes $\left(x_{1} ight)$. b. Test for...
-
Answer the following questions on buses going a curve. 1. When a bus goes around a flat curve, the direction of the friction force is in the direction of the: A- normal acceleration B- tangential...
-
Eliot Sprinkler Systems produces equipment for lawn irrigation. One of the parts used in selected Eliot equipment is a specialty nozzle. The budgeting team is now determining the purchase...
-
An investment center of Lannigan Company reported operating income of $360,000 on total operating assets of $2,660,000 c the current year. The company has established a target ROI of 16.00% for the...
-
2. Consider the following grammar: S- aS/bA A = Show the detail procedure of parsing 'a b b' in LL(1) parsing.
-
How do I follow the following equations y=2x x=-y + 6
-
An important part of the marketing research and decision process includes setting a realistic price. From the seller's point of view, the higher the price, the more profit it will make. From the...
-
A sales engineer claims that his pump is economically justifiable. He says that for a cost of P250,000.00, it will have a market value of P30,000 at the end of 10 years. If the increased productivity...
-
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?
-
The hangers support the joist in such a way that the four nails on each hanger can be assumed to support an equal portion of the load. If the joist is subjected to the loading shown, determine the...
-
The hangers support the joist in such a way that the four nails on each hanger can be assumed to support an equal portion of the load. Determine the smallest diameter of the nails at A and B to the...
-
The 60 mm x 60 mm oak post is supported on the pine block. If the allowable bearing stresses for these materials are oak = 43 MPa and pine 25 MPa, determine the greatest load P that can be...
Study smarter with the SolutionInn App