Question

In: Accounting

Tom used to run his own business, a small café. Last year, due to water damage...

Tom used to run his own business, a small café. Last year, due to water damage from a flash flood, not only did he lose a substantial part of his inventory; but his café also sustained damages. In order to carry on the business, he sold the café to his friend, Bill, who invested money to replace/repair damaged shop fixtures and machines, and to purchase new inventory. The small café offers coffee and tea, and light food snacks bought from outside suppliers. The snacks are heated up in the café and served. There is only one other worker, a waiter. Tom is now the manager. Between the two of them, they make drinks, serve customers, and clean up.

When he was running his own business, Tom did not receive a salary. Now he is paid $2,500 per month. The waiter is paid $1,000 a month. They both work from 9 am to 8 pm, six days a week. Tom is also in charge of purchasing for the café. In the past, he bought inventory in bulk to get a lower price. However, as the inventory is perishable, it often spoils and at the end of each quarter about 30% is thrown away. This spoilage cost has been factored into the cost of ingredients per set. The café sells drink & snacks in a set. The average ingredient costs for each set is $2.20 and it is sold at $4 per set. Rent and utilities average $2,500 per month. The business uses the number of sets as an allocation base for its overhead costs.

The budgeted sales for the next five quarters for the café are stated below:

No. of sets
Quarter 1 of 2018 11,200
Quarter 2 of 2018 12,400
Quarter 3 of 2018 22,600
Quarter 4 of 2018 25,800
Quarter 1 of 2019 14,400

Required:

(a) Apply normal costing and compute the product cost for a typical set (hint: fixed costs should be allocated using an appropriate predetermined overhead rate).

(b) If Tom is evaluated based on budgeted profit for the café, explain how Bill should rate Tom’s performance for the first two quarters of 2018 if the actual sales for the café are as follows (assume there are differences in the budgeted and actual costs per set of meal and selling price per set of meal).

Actual no of sets
Quarter 1 of 2018 13,200
Quarter 2 of 2018 12,000

(c) The café pays for purchases of ingredients one quarter later. All other expenses are paid for in cash in the same quarter. Assuming the café has a cash balance of $28,400 and no outstanding ingredients payments at the beginning of 2018 from purchases in Quarter 4 of 2017, construct the cash budget for Quarter 2 and Quarter 3 of 2018.

Solutions

Expert Solution

Answers:

a.

$5.8

b.

Bill should measure his performance on the basis of his actual performance.

c.

Quarter 2 = $62,160

Quarter 3 = $107,280

Explanation:

a.)

Compute the product cost as follows:

Here, it has been considered that no. of sets are 5,000.

Product cost = $2.20 + [($2,500 + $1,000 + $2,500) * 3 / 5,000]

                    = $5.8

b.

Compute budgeted profit for the quarters 1 and 2 as follows:

Quarter 1 = 11,200 * ($4 - $2.20)

               = $20,160

Quarter 2 = 12,400 * ($4 - $2.20)

               = $22,320

If bill is rating Tom's performance of first two quarters then in one quarter he sold more set of ingredients than estimated and in other quarter, he sold lesser number of ingredients. However, the fact that 30% of the inventory at the quarter end has to be thrown away should be considered.

c.

Prepare the cash budget for quarter 2 and 3 of 2018 as follows:

Particulars Quarter 1 Quarter 2 Quarter 3
opening cash $28,400 $55,200 $62,160
Sale $44,800 (11,200 × $4) $49,600 (12,400 × $4) $90,400 (22,600 × $4)
Less: cost of incredients $0 $24,640 (11,200 × $2.20) $27,280 (12,400 × $2.40)
Less money paid to Tom and Waiter $10,500 =($2500+$10,000) × $3 $10,500 =($2500+$10,000) × $3 $10,500 =($2500+$10,000) × $3
Less: Rent and utilities $7,500 = $2,500 × 3 $7,500 = $2,500 × 3 $7,500 = $2,500 × 3
Cash balance $55,200 $62,160 $107,280

Related Solutions

"Business Expenditures and Deductions" Avery has always wanted to own his own business. Last year, he...
"Business Expenditures and Deductions" Avery has always wanted to own his own business. Last year, he took the leap and opened a pet store in a nearby city. He leases the store. He incurred start-up costs and large inventory costs for buying food in bulk. He had to purchase three large tables and a machine that moves the food to higher shelves for storage. He even hired five people: a groomer, two clerks, a stock person, and a bookkeeper. Unfortunately,...
Tom O'Neal always wanted to own his own business. When he was in high school, he...
Tom O'Neal always wanted to own his own business. When he was in high school, he worked evenings and most weekends at a neighborhood bicycle shop. When Tom went to college at the nearby State University, he still came home in the summers and worked at the bike shop. Upon graduation from college, with his accounting degree in hand, the sole proprietor (Steven Judson) of the bike shop invited Tom to become a full partner in the bike shop. Steven...
Tom owns 22 hotdog stands. Tom earned $10,000 last year from the hotdog stands business. For...
Tom owns 22 hotdog stands. Tom earned $10,000 last year from the hotdog stands business. For $4000, Tom can build two more stands, each stand costs $2000. Assume it costed Tom $2000 to build each of 22 stands. If Tom has 24 stands instead of 22, its yearly income will rise from $10,000 to $11,000. Let’s assume Tom indeed added two more stands using the money he earned last year. David Everything is the same except for David borrows $4000...
Tom Belford and Tony Sorrentino own a small business devoted to kitchen and bath granite installations....
Tom Belford and Tony Sorrentino own a small business devoted to kitchen and bath granite installations. Recently, building contractors have insisted on up-front bid prices for a house rather than the cost-plus system that Tom and Tony had been using. They worry because natural flaws in the granite make it impossible to tell in advance exactly how much granite will be used on a particular job. In addition, granite can be easily broken, meaning that Tom or Tony could ruin...
Q7. Mr. Q started his own business.   As it is a very small business with little...
Q7. Mr. Q started his own business.   As it is a very small business with little investment and very less transactions, he does not want to hire any employees to record the transactions happening in the business. As he is not from an Accounting background, he finds it very difficult to understand how to classify the transactions and record. Some transactions are given to you to help him classify transactions category under A) Current Assets B) Current Liabilities C) Long...
Setting Standards, Materials and Labor Variances Tom Belford and Tony Sorrentino own a small business devoted...
Setting Standards, Materials and Labor Variances Tom Belford and Tony Sorrentino own a small business devoted to kitchen and bath granite installations. Recently, building contractors have insisted on up-front bid prices for a house rather than the cost-plus system that Tom and Tony had been using. They worry because natural flaws in the granite make it impossible to tell in advance exactly how much granite will be used on a particular job. In addition, granite can be easily broken, meaning...
Setting Standards, Materials and Labour Variances Tom Belford and Tony Sorrentino own a small business devoted...
Setting Standards, Materials and Labour Variances Tom Belford and Tony Sorrentino own a small business devoted to kitchen and bath granite installations. Recently, building contractors have insisted on up-front bid prices for a house rather than the cost-plus system that Tom and Tony were used to. They worry because natural flaws in the granite make it impossible to tell in advance exactly how much granite will be used on a particular job. In addition, granite can be easily broken, meaning...
Tom paid $17k in mortgage interest and $8k in property taxes last year. His average tax...
Tom paid $17k in mortgage interest and $8k in property taxes last year. His average tax rate is 21.5%, his marginal tax rate is 28%. Compute Tom’s tax shield from the mortgage interest and property tax deduction.
Mr. Tom Costa, age 71, had a stroke last year that made his right upper and...
Mr. Tom Costa, age 71, had a stroke last year that made his right upper and lower extremities quite weak. He has smoked for 55 years and is obese. He was diagnosed with atrial fibrillation, high blood pressure, and type 2 diabetes mellitus while he was hospitalized with his stroke. His father died of a heart attack at age 50; his paternal grandfather had a stroke and died a year later after a second stroke. His mother and both of...
Tom, Dicck, and Harry are all in the bottled-water business. If one or two of them...
Tom, Dicck, and Harry are all in the bottled-water business. If one or two of them expand their production, they can take business away from those who do not, but if all expand, they will be back to a break-even situation. Here are the payoffs. Harry Expand No Dicck Dicck Expand No Expand No Tom Expand 0,0,0 1,-2,1 1,1,-2 2,-1,-1 No -2,1,1 -1,-1,2 -1,2,-1 0,0,0 Has this game any Nash equilibria? If so, list them and explain.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT