Tom's Shoe Repair provides a variety of shoe repair services. Analysis of monthly costs revealed the...

Tom's Shoe Repair provides a variety of shoe repair services. Analysis of monthly costs revealed the following cost formulas when direct labor hours are used as the basis of cost determination:

Supplies: y=$0+$4.00X

Production supervision and direct labor: y=$500+$7.00X

Utilities: y=$350+$5.40X

Rent: y=$450+$0.00X

Advertising: y=$75+$0.00X

a. Prepare a flexible budget 250, 300, 350, and 400 direct labor hours.

b. Calculate a total cost per direct labor at each level of activity.

c. Tom's employees usually work 350 direct labor hours per month. The average shoe repair requires 1.25 labor hours to complete. Tom wants to earn a 40 percent margin on his cost. What should be the average charge per customer, rounded to the nearest dollar to achieve Tom's profit objective?

*Don not use excel or any other software to solve this problem

Solutions

Expert Solution

Tom’s Shoe Repair

Flexible Budget 250, 300, 350 and 400 direct labor hours:

Tom's Shoe Repair
Flexible Budget
at Multiple Levels of Direct Labor Hours
Direct labor hours	250	300	350	400
Variable Costs:
Supplies at $4 per DLH	$1,000	$1,200	$1,400	$1,600
Production supervision and direct labor at $7 per DLH	$1,750	$2,100	$2,450	$2,800
Utilities at $5.40	$1,350	$1,620	$1,890	$2,160
Total variable cost	$4,100	$4,920	$5,740	$6,560
Fixed Costs:
Production supervision and direct labor	$500	$500	$500	$500
Utilities	$350	$350	$350	$350
Rent	$450	$450	$450	$450
Advertising	$75	$75	$75	$75
Total fixed cost	$1,375	$1,375	$1,375	$1,375
Total Cost	$5,475	$6,295	$7,115	$7,935

Calculation of total cost per direct labor hour at each level of activity:

Level of Activity	Total Cost	Total Cost per DLH
250 DLH	$5,475	$21.90
300 DLH	$6,295	$20.98
350 DLH	$7,115	$20.33
400 DLH	$7,935	$19.84

Determination of the average charge per customer, to achieve Tom’s profit objective:

At 350 DLH activity, the total cost per DLH = $20.33

Average shoe repair time = 1.25 hours

Average shoe repair cost = $20.33 x 1.25 = $25.41

Margin on cost at 40% -

Equation to arrive at the average charge per customer,

Average charge = total cost per DLH + Gross Margin

= $25.41 + (0.4 x Average Charge)

0.6 x Average Charge = $25.41

Average Charge = 25.41/0.60 = $42.35

Gross margin = 42.35 – 25.41 = $16.94

Hence, average charge per customer to achieve 40% gross margin = $42.35

ekkarill92 answered 8 months ago

Next > < Previous

Related Solutions

Thunderduck Car Repair is a company that provides car repair services and is in its second...

Thunderduck Car Repair is a company that provides car repair services and is in its second year of operations. The company uses accrual basis accounting and follows GAAP. Financial statements must be provided monthly to the company’s lender, White Rock Bank, on a monthly basis. Assignment Record January transactions in the General Journal and post to the General Ledger. Record adjusting entries for January in the General Journal and post to the General Ledger. Prepare the adjusted trial balance as...

Fix 4 Less is a company for cellphone repair. The business offers variety of services such...

Fix 4 Less is a company for cellphone repair. The business offers variety of services such as refurbishing the screens, selling the parts online (amazon, eBay and bonanza), retail store for walk in customers and mobile repair services for those who don't have time to leave their homes or works. Business would like to add one more service which is selling the parts wholesale to other retail stores in the same market. After everything is settled business is planning to...

Allcott Computer Services (ACS) provides computer training and repair services for schools and local businesses. Sales...

Allcott Computer Services (ACS) provides computer training and repair services for schools and local businesses. Sales for year 1 totaled $2,700,000. Information regarding resources for the year includes the following: Resources Used Resources Supplied Marketing $ 221,000 $ 235,000 Depreciation 171,000 180,000 Training personnel 90,000 106,000 Energy 159,000 173,000 Short-term labor 410,000 600,000 Long-term labor 840,000 850,000 Administrative 131,000 155,000 In addition, ACS spent $86,000 on 530 repair verifications with a cost driver rate of $150. Required: Management has...

Fix 4 Less is a company for cellphone repair. The business offers variety of services s......

Fix 4 Less is a company for cellphone repair. The business offers variety of services s... Question: Fix 4 Less is a company for cellphone repair. The business offers variety of services such as refurbishing the screens, selling the parts online (amazon, eBay and bonanza), retail store for walk in customers and mobile repair services for those who don't have time to leave their homes or works. Business would like to add one more service which is selling the parts...

Western Technical Services is a small engineering firm in Colorado that provides a variety of technical...

Western Technical Services is a small engineering firm in Colorado that provides a variety of technical and drafting services. Western Technical Services employs three engineers, five drafters, and three secretaries. Western has developed a leading reputation in the design of low-capacity and medium-capacity heat exchangers for electrical equipment. A large backlog of jobs has accumulated, and the firm has decided it must complete the back orders. The firm wants to maximize the number of jobs finished each day to eliminate...

Profitability Analysis Assume a local Cost Cutters provides cuts, perms, and hairstyling services. Annual fixed costs...

Profitability Analysis Assume a local Cost Cutters provides cuts, perms, and hairstyling services. Annual fixed costs are $120,000, and variable costs are 40 percent of sales revenue. Last year's revenues totaled $250,000. (a) Determine its break-even point in sales dollars. $ Answer (b) Determine last year's margin of safety in sales dollars. $ Answer (c) Determine the sales volume required for an annual profit of $80,000. Multiple Product Break-Even Analysis Presented is information for Stafford Company's three products. A B...

3-27. The Georgeville city government provides a wide variety of services to the community. Among them...

3-27. The Georgeville city government provides a wide variety of services to the community. Among them is the protection provided by the police force. In order to provide that force, it spends $3 million on salaries, $200,000 on vehicle costs, and $300,000 on supplies. The police force expects to have 7,000 measurable actions, consisting of 1,000 arrests, 4,000 traffic citations, and 2,000 responses to emergency calls. It has noted that the average cost for each one of these actions is...

Revenue recognition – accrual basis vs. cash basis: Ring The Bells, Inc. provides doorbell repair services...

Revenue recognition – accrual basis vs. cash basis: Ring The Bells, Inc. provides doorbell repair services to customers and began operations in February 2018. On March 4th, 2018, Ring The Bells, Inc. collected $2,400 in cash from customers for services performed in February 2018. On March 11th, Ring The Bells, Inc. provided $690 worth of services to customers, all of whom paid in cash. On March 25th, 2018 Ring the Bells provided additional services worth $3,470 on account to customers,...

University Inn's most recent monthly expense analysis report revealed significant cost overruns. The manager was asked...

University Inn's most recent monthly expense analysis report revealed significant cost overruns. The manager was asked to explain the deviations. Below is the "budget v. actual" expense report for the month in question. University Inn Budget vs. Actual Expense Report For The Month Ending October 31, 20X7 Actual Budget Variance Utilities $52,000 $45,000 ($7,000) Laundry 20,000 18,000 ($2,000) Food service 41,000 35,000 ($6,000) Rent/taxes 60,000 60,000 $0 Staff wages 57,000 55,000 ($2,000) Management salaries 43,500 45,000 $1,500 Water 13,000 10,000...

University Inn's most recent monthly expense analysis report revealed significant cost overruns. The manager was asked...

University Inn's most recent monthly expense analysis report revealed significant cost overruns. The manager was asked to explain the deviations. Below is the "budget v. actual" expense report for the month in question. University Inn Budget v. Actual Expense Report For the Month Ending October 31, 2007 Actual (at 96% capacity) Budget (established at 80% capacity) Variance Utilities $ 52,000 $ 45,000 $ (7,000) Laundry 20,000 18,000 (2,000) Food service 41,000 35,000 (6,000) Rent/taxes 60,000 60,000 - Staff wages 57,000...

Subjects