Prepare a cash budget for may

Assignment Help Cost Accounting
Reference no: EM131753503

Cost Accounting Final

1. Cash budget

Sales for April, May, and June are expected to be $200,000, $180,000, and $220,000, respectively, for the Momo's Donuts. All sales are on account (terms 2/15, net 30 days) and are collected 50 percent in the month of sale and 50 percent in the following month. One-half of all sales discounts are taken on the average. Materials are purchased one month before being needed, and all purchases and expenses are paid for as incurred. Activities for the quarter are expected to be:

 

April

May

June

Materials used

$40,000

$36,000

$44,000

Salaries

70,000

68,000

72,000

Maintenance and repairs

18,000

18,000

18,000

Depreciation

36,000

36,000

36,000

Utilities and other

14,000

14,000

14,000

Dividends paid

-0-

10,000

-0-

Payment on bonds

8,000

8,000

8,000

Required: Using the given information, prepare a cash budget for May.

2. Material and labor variance

Brainerd Chemical Company manufactures 100-pound bags of chemicals that have the following unit standard costs for direct materials and direct labor:

Direct materials (100 lbs. @ $1.00 per lb.)

$100.00

Direct labor (0.5 hours at $24 per hour)

  12.00

Total standard direct cost per 100 lb. bag

$112.00

The following activities were recorded for October:

- 1,000 bags were manufactured.
- 95,000 lbs. of materials costing $76,000 were purchased.
- 102,500 lbs. of materials were used.
- $12,000 was paid for 475 hours of direct labor.

There were no beginning or ending work-in-process inventories.

Required:

a. Compute the direct materials variances.
b. Compute the direct labor variances.
c. Give possible reasons for the occurrence of each of the preceding variances.

3. JIT and product cost

Spiratex Company used machine hours to assign maintenance costs to its three products of 3-inch, 5-inch, and 7-inch plastic tubing, then they installed a JIT system.

Maintenance costs $120,000/ year.
Machine hours used by each product and the quantity produced of each product are as follows:

 

Machine Hours

Quantity Produced

3-inch

1,000

400 rolls

5-inch

1,500

450 rolls

7-inch

2,500

1,250 rolls

After installing JIT, three manufacturing cells were created and the cell workers were trained to perform maintenance. Maintenance costs for the three cells still totaled $120,000; however, these costs are now traceable to each cell.

Cell, 3-inch

$20,000

Cell, 5-inch

32,400

Cell, 7-inch

67,600

Required:

a. Compute the maintenance cost per roll for each type of tubing before JIT is installed.
b. Compute the maintenance cost per roll for each type of tubing after JIT is installed.
c. Explain why the JIT maintenance cost per roll is more accurate than the cost per roll using the traditional approach.

4. Cost report
Zebco, Inc., has developed ideal standards for four activities: labor, materials, inspection, and receiving.

Information is as follows:

Activity

Activity Driver

    SQ  

    AQ

  SP

Labor

Hours

30,000

38,000

$11

Materials

Pounds

110,000

160,000

10

Inspection

Inspection hours

0

50,000

7

Receiving

Orders

600

700

450

The actual prices paid per unit of each activity driver were equal to the standard prices.

Required:

Complete the following cost report:

Activity

Value-Added

Non-value-Added

Actual

 

Labor

 

$                      

 

$                      

 

$                      

 

Materials

 

$                      

 

$                      

 

$                      

 

Inspection

 

$                      

 

$                      

 

$                      

 

Receiving

 

$                      

 

$                      

 

$                      

 

Totals

 

$                      

 

$                      

 

$                      

5. Balanced Scorecard and Strategy

Chico's is a local clothing store in Tulsa. Chico's has been experiencing increased competition from the national clothing chains. In an effort to improve performance, management intends to create a Balanced Scorecard. In a meeting, several measures were suggested by various managers.

Management has identified a key problem. Customers are taking too long to pay their department store's charge card bills, and the company has an abnormal amount of bad debts. If this problem were solved, the company would have far more cash to invest in store improvements. Investigation has revealed that much of the problem with late payments and unpaid bills is apparently due to disputes about incorrect charges on the customer bills. Incorrect charges usually occur because sales clerks enter data incorrectly on the charge account slip.

The performance measures suggested by the managers are given below:

- Total sales revenue
- Sales per square foot of floor space
- Sales to inventory ratio
- Sales per employee
- Sales to total assets
- Customer satisfaction with accuracy of charge account bills from monthly customer survey
- Customer wait time for service
- Travel expenses for buyers' trips
- Average age of accounts receivable
- Courtesy shown by junior staff members based on surveys of senior staff
- Unsold inventory at the end of the season as a percentage of total cost of sales
- Percentage of suppliers making just-in-time deliveries
- Quality of food in the staff cafeteria based on staff surveys
- Written-off accounts receivable as a percentage of sales
- Percentage of charge account bills containing errors
- Percentage of employees who have attended the city's cultural diversity workshop
- Total profit
- Profit per employee
- Percentage of salesclerks trained to correctly enter data on charge account slips

Required:

a. Build an integrated Balanced Scorecard using only performance measures suggested by the managers. You do not have to use all the measures, but build a Balanced Scorecard that reveals a strategy for dealing with the problems with accounts receivable and unsold merchandise.

b. Construct a testable strategy by showing the causal links (with arrows) between measures in the different perspectives, and show whether the performance measure should show an increase or decrease.

c. Assume that the company adopts the Balanced Scorecard. After operating for a year, there are improvements in some performance measures but not in others. What should management do next?

6. Contribution margin and break-even

TMA Systems had the following functional income statement for the month of November, 2017:

Sales ($20 × 20,000 units)

 

$400,000

Costs of goods sold:

 

 

Direct materials

$ 60,000

 

Direct labor

40,000

 

Variable factory overhead

120,000

 

Fixed factory overhead

  50,000

 270,000

Gross profit

 

$130,000

Selling and administrative expenses:

 

 

Variable

$ 20,000

 

Fixed

  50,000

  70,000

Operating income

 

$ 60,000

There were no beginning and ending inventories.

Required:

7. Contribution margin break-even and margin of safety

At a price of $48, the estimated monthly sales of a product are 18,000 units. Variable costs include manufacturing costs of $27 and distribution costs of $9. Fixed costs are $60,000 per month.

Required:

Determine each of the following values:

a. Unit contribution margin
b. Monthly break-even unit sales volume
c. Before-tax monthly profit
d. Monthly margin of safety in units

Verified Expert

The current assignment relates to the project related to cost and financial management. There are certain questions in it and analyst has worked over it . For the first part there is a problem related to cash budget, continuing with that expert calculated various types of variances. The manufacturing cost of Roll before implementing JIT and after implementing JIT is calculated. There is a layout on information and extract on balance scorecard. Towards the end of the assignment there are few questions on marginal costing as well.

Reference no: EM131753503

Questions Cloud

What is the highest price the stock has been over last year : Now look at recent stock price movements. What is the highest price the stock has been over the last year? The lowest price over the last year?
Discuss estimate of fixed costs for fleet operating expenses : What is the best estimate of fixed costs for fleet operating expenses in 2014 using the high-low method
Prepare the closing entries at december : The ledger of Swann Company contains the following balances: Retained Earnings $30,000; Prepare the closing entries at December 31
Summarize what pixar says makes their braintrust : Summarize what Pixar says makes their braintrust. List the characteristics and how it works. Where did it come from, why does it work for Pixar.
Prepare a cash budget for may : Prepare a cash budget for May - Compute the direct materials variances and Compute the maintenance cost per roll for each type of tubing before JIT is installed
Compute the amount of pamello current year deductions : Prepaid Expenses. Pamello, Inc., an engineering consulting firm, uses the cash method of accounting. Compute the amount of Pamello's current year deductions
Discuss what will be the increase in caris monthly gas bill : What will be the increase in Cari's monthly gas bill per heating degree-day using the high-low method
Discuss your pricing strategies in detail use tables : Discuss the Cost, Price & Profitability: Discuss your pricing strategies in detail (use tables, charts if necessary).
Discuss the benefits using an experimental design : In this discussion, be sure to examine how the different research procedures might help to convey results to different audiences.

Reviews

inf1753503

4/23/2018 5:51:10 AM

Thank you for your continued help on my cost accounting papers. Please thank the expert profusely for taking this on so last minute. Thanks for running a great service for the students like me. Amazing service you have.

Write a Review

Cost Accounting Questions & Answers

  Cost accounting assignment

Evaluate Method of measuring costs associated with production, budgeting process, normal job-order costing system , master budget, cycle time.

  Prepare the journal entries

Prepare the journal entries to record the bond issue and interest expense.

  Advise as to the liability of all the parties

Write a report on given case study and Advise as to the liability of ALL the parties both under common law and the Corporations Law.

  Prepare revenues budget

Prepare Revenues budget and Production budget in units

  Effect of exchange rate changes on cash and cash

Effect of exchange rate changes on cash and cash

  Corporate governance

You are to reflect on how this case of China Sky relates to what the arguments for and against allowing audit firm partners and/or employees to join audit committees.

  Cost-benefit analysis

A cost-benefit analysis of electronic medical records in primary care

  Non-annual interest rates and annuities

Theory of Interest- Non-annual interest rates and annuities

  Job costing in service organizations

How is job costing in service organizations different from job costing in manufacturing environments?

  Accounting for bad debt expense

Accounting for bad debt expense

  Accounting and partnership problems

Accounting and Partnership problems

  Development of relevant cash flows

Development of relevant cash flows - Cost estimating and financial analysis

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd