Prepare a schedule of expected cash collections from sales

Assignment Help Managerial Accounting
Reference no: EM132238198

Question 1

TabComp Inc. is a retail distributor for MZB-33 computer hardware and related software. TabComp prepares annual sales forecasts, of which the first six months of the coming year are presented below:


Hardware Units

Hardware Dollars

Software
Dollars

Total Sales

January

130

$390,000

$160,000

$550,000

February

120

360,000

140,000

500,000

March

110

330,000

150,000

480,000

April

90

270,000

130,000

400,000

May

100

300,000

125,000

425,000

June

125

375,000

225,000

600,000

Cash sales account for 25% of TabComp's total sales, 30% of the total sales are paid by bank credit card, and the remaining 45% are on open account (TabComp's own charge accounts). The cash and bank credit card sale payments are received in the month of the sale. Bank credit card sales are subject to a 4% discount, which is deducted immediately. The cash receipts for sales on open account are 70% in the month following the sale and 28% in the second month following the sale; the remaining are uncollectible.

TabComp's month-end inventory requirements for computer hardware units are 30% of the next month's sales. The units must be ordered two months in advance due to long lead times quoted by the manufacturer.

Calculate the cash that TabComp can expect to collect during April. Show all of your calculations.

Determine the number of computer hardware units that should be ordered in January. Show all of your calculations.

Question 2
Peak sales for Blizzard Inc., a wholesale distributor of snow shovels, occur in November. The company's sales budget for the fourth quarter showing these peak sales is given below:


October

November

December

Total

Budgeted sales (all on account)

$400,000

$800,000

$700,000

$1,900,000

From past experience, the company has learned that 25% of a month's sales are collected in the month of sale, another 70% are collected in the month following sale, and the remaining 5% are collected in the second month following sale. Bad debts are negligible and can be ignored. August sales totaled $70,000, and September sales totaled $180,000.

Prepare a schedule of expected cash collections from sales, by month and in total, for the fourth quarter.

Assume that the company will prepare a budgeted balance sheet as of September 30. Compute the accounts receivable as of that date.

Question 3

An incomplete monthly flexible budget is given below for Bubbles Inc., a company that owns and operates a large automatic car wash facility.

Fill in the missing data in the flexible budget.

Bubbles Inc.

Flexible Budget



Monthly Activity (car washed)


Per Car

7,000

8,000

9,000

Sales

?

?

$80,000

?

Variable expenses:





Cleaning supplies

?

?

6,000

?

Utilities

?

?

4,800

?

Maintenance

?

?

1,200

?

Total variable expenses

?

?

?

?

Contribution margin

?

?

?

?

Fixed expenses:





Operator wages


?

10,000

?

Depreciation


?

20,000

?

Rent


?

8,000

?

Insurance


?

1,000

?

Selling and administrative


?

4,000

?

Total fixed expenses


?

43,000

?

Operating income


?

?

?

Question 4

Five years ago, Phil Coulson left his position at a large company to start Coulson Spy Solutions Co. (CSS), a software design and tracking company. CSS's first product was a unique software package that seamlessly integrates networked PCs. Robust sales of this initial product permitted the company to begin development of other software products and to hire additional personnel. The staff at CSS quickly grew from three people working out of Phil's basement to more than 70 individuals working in leased spaces at an industrial park. Continued growth led Coulson to hire seasoned marketing, distribution, and production managers and an experienced accountant.

Recently, Coulson decided that the company had become too large to run on an informal basis and that a formalized planning and control program centered around a budget was necessary. Coulson asked the accountant, Maria Hill, to work with him in developing the initial budget for CSS.

Coulson forecasted sales revenues based on his projections for both the market growth for the initial software and successful completion of new products. Hill used this data to construct the master budget for the company, which she then broke down into departmental budgets. Coulson and Hill met a number of times over a three-week period to hammer out the details of the budgets.

When Coulson and Hill were satisfied with their work, the various departmental budgets were distributed to the department managers with a cover letter explaining CSS's new budgeting system. The letter requested everyone's assistance in working together to achieve the budget objectives. Several of the department managers were displeased with how the budgeting process was undertaken. In discussing the situation among themselves, they felt that some of the budget projections were overly optimistic and not realistically attainable.

How does the budgeting process Coulson and Smith used at CSS differ from recommended practice?

What are the behavioural implications of the way Coulson and Hill went about preparing the master budget?

Verified Expert

Assignment relates to managerial accounting.Question 1 and 2 relates to calculation of Cash Collection and Balance in Accounts Receivable.In ques 3 the flexible budget was provided with few missing figures which are calculated.Ques 4 discusses about the budgeting process and behavioral implications of the preparation of the master budget.

Reference no: EM132238198

Questions Cloud

What do you like about their website : What is the web address? What do you like about their website? What do you think could be improved about their website?
Describe the business project and the investment : Describe the business project and the investment choice to be made - Determine which lighting figures offered lowest cost in PV terms at the hotel's quality
Why did these journalists and columnist attack his candidacy : Why did these journalists and columnists attack his candidacy? Please explain three of the reasons that Frank suggests. Then, evaluate his methodology.
Should northcom be given a broader role in homeland : It is often said that NORTHCOM is the "heavy lifter of last resort." What do you think that means?
Prepare a schedule of expected cash collections from sales : How does the budgeting process Coulson and Smith used at CSS differ from recommended practice - What are the behavioural implications of the way Coulson
Calculate and interpret LCCs financial leverage : Using the data found in Exhibit 1 and Exhibit 2, calculate and interpret LCC's financial leverage in 2017 as compared with 2016
Provide a synopsis of the project : Provide a synopsis of the project, why it was selected, which CO or COs it meets, presentation of your findings or outcomes, your management assessment
Identify your population and demographics and campaign : Identify your population and demographics and campaign. Explain your two communications pieces.
How do you plan to use it to assist others : We're helping Americans through the Great Depression, the treasurer of a Midwestern credit union said that credit unions were "not for profit.

Reviews

len2238198

2/20/2019 4:17:05 AM

At the end of each chapter is a series of Unit Exercises. Students are to complete the exercises in Word (or some other compatible word processor) and submit. • To understand and solidify introductory financial accounting course concepts and techniques

Write a Review

 

Managerial Accounting Questions & Answers

  Calculate profit change attributable to productivity changes

Calculate the partial productivity ratios for each year. Can you say that produc- tivity has improved? Explain. Calculate the profit change attributable to productivity changes.

  Given the data in the table and the graph

Explain your answers. Given the data in the table and the graph, what type of market structure could this be in the short run? Explain your answers. If the data in Table-1 represents the long run, what type of firm must this data represent? Explain y..

  Identity and critically examine the underlying assumptions

Identity and critically examine the underlying assumptions of this type cost-volume-profit analysis and consider whether such analyses are useful the management of an organisation.

  Conduct a multiple regression of overhead

Develop scatter diagrams showing overhead costs against each of the proposed independent variables. Comment on whether these scatter diagrams indicate that linearity is a reasonable assumption for each.

  Prepare a budgeted balance sheet as of the end

Prepare a budgeted balance sheet as of the end of the first quarter of 2012.

  The adjusted trial balance amounts at june

Skolnick Co. was organized on April 1, 2010.The company prepares quarterly financial statements. The adjusted trial balance amounts at June 30 are shown below.

  Prepare the companys cash budget for october

Prepare the company's cash budget for October in good form. Make sure to indicate what borrowing, if any, would be needed to attain desired ending cash balance

  Questionnbspnbspthe rohr companys old equipment for making

questionnbspnbspthe rohr companys old equipment for making subassemblies is worn out. the company is considering two

  Analysis of misinformation in management

Now, you need to fast-forward to the present. After reading the case, craft your own version of misinformation in management by developing five (5) key incorrect assumptions that management makes about its accounting information systems.

  Master in marketing

Master in Marketing Module: Data driven Marketing research and analysis Subject: The role and importance of market research for today's organizations and the marketing research process

  Calculate the net present value of each of each option

Calculate the cash flows for years one through four for each option and calculate the net present value of each of each option. Assume a 12% discount rate.

  Decisions based on motivation and emotion

Is it possible the extroversion personalities make decisions based on motivation and emotion?

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