Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN: 9781305970663
Author: Don R. Hansen, Maryanne M. Mowen
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 8, Problem 11CE
Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the follow sales:
In Shalimar’s experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are $4,900,000 and for the fourth quarter of the current year are $6,850,000.
Required:
- 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year.
- 2. Construct a cash receipts budget for Shalimar Company for each quarter of the next year, showing the cash sales and the cash collections from credit sales.
- 3. What if the recession led Shalimar’s top management to assume that in the next year 10 percent of credit sales would never be collected? The expected payment percentages in the quarter of sale and the quarter after sale are assumed to be the same. How would that affect cash received in each quarter? Construct a revised
cash budget using the new assumption.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales:
Quarter 1
$4,620,000
Quarter 2
5,150,000
Quarter 3
4,890,000
Quarter 4
8,480,000
In Shalimar’s experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are $5,040,000 and for the fourth quarter of the current year are $7,680,000.
Required:
Question Content Area
1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year.
Quarter
Cash Sales
Credit Sales
3, current year
$fill in the blank 1d3d12fb3fb1016_1
$fill in the blank 1d3d12fb3fb1016_2
4, current year
fill in the blank…
Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales:
Quarter 1
$4,740,000
Quarter 2
5,860,000
Quarter 3
3,720,000
Quarter 4
8,580,000
In Shalimar’s experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are $5,410,000 and for the fourth quarter of the current year are $7,070,000.
Required:
Question Content Area
1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year.
Quarter
Cash Sales
Credit Sales
3, current year
$fill in the blank 9d2fe401a04bf88_1
$fill in the blank 9d2fe401a04bf88_2
4, current year
fill in the blank…
Maraa Company's budget includes the following credit sales for the current year: August, $25,000; September, $36,000; October, $30,000; November, $32,000. Experience has shown that payment for the credit sales is received as follows: 15% in the month of sale, 60% in the first month after sale, 20% in the second month after sale, and 5% is uncollectible. How much cash can Marra expect to collect in October as a result of current and past credit sales?
Group of answer choices
1)$19,700.
2)$30,000.
3)$31,100.
4)$28,500.
5)$33,900.
Chapter 8 Solutions
Cornerstones of Cost Management (Cornerstones Series)
Ch. 8 - Define budget. How are budgets used in planning?Ch. 8 - Prob. 2DQCh. 8 - Prob. 3DQCh. 8 - What is the master budget? An operating budget? A...Ch. 8 - Explain the role of a sales forecast in budgeting....Ch. 8 - All budgets depend on the sales budget. Is this...Ch. 8 - What is an accounts receivable aging schedule? Why...Ch. 8 - Suppose that the vice president of sales is a...Ch. 8 - Suppose that the controller of your companys...Ch. 8 - Prob. 10DQ
Ch. 8 - Prob. 11DQCh. 8 - Discuss the shortcomings of the traditional master...Ch. 8 - Define static budget. Give an example that shows...Ch. 8 - What are the two meanings of a flexible budget?...Ch. 8 - What are the steps involved in building an...Ch. 8 - FlashKick Company manufactures and sells soccer...Ch. 8 - Refer to Cornerstone Exercise 8.1, through...Ch. 8 - Refer to Cornerstone Exercise 8.2 for the...Ch. 8 - Prob. 4CECh. 8 - Johnston Company cleans and applies powder coat...Ch. 8 - Play-Disc makes Frisbee-type plastic discs. Each...Ch. 8 - Refer to Cornerstone Exercise 8.6. Required: 1....Ch. 8 - Timothy Donaghy has developed a unique formula for...Ch. 8 - Green Earth Landscaping Company provides monthly...Ch. 8 - Coral Seas Jewelry Company makes and sells costume...Ch. 8 - Shalimar Company manufactures and sells industrial...Ch. 8 - Khloe Company imports gift items from overseas and...Ch. 8 - Nashler Company has the following budgeted...Ch. 8 - Refer to Cornerstone Exercise 8.13. In March,...Ch. 8 - Palmgren Company produces consumer products. The...Ch. 8 - Prob. 16ECh. 8 - Crescent Company produces stuffed toy animals; one...Ch. 8 - Audio-2-Go, Inc., manufactures MP3 players. Models...Ch. 8 - Tiger Drug Store carries a variety of health and...Ch. 8 - Rosita Flores owns Rositas Mexican Restaurant in...Ch. 8 - Prob. 21ECh. 8 - Janet Wooster owns a retail store that sells new...Ch. 8 - Historically, Ragman Company has had no...Ch. 8 - Del Spencer is the owner and founder of Del...Ch. 8 - Refer to Exercise 8.24. Del Spencers purchases...Ch. 8 - Ingles Corporation is a manufacturer of tables...Ch. 8 - In an attempt to improve budgeting, the controller...Ch. 8 - Refer to Exercise 8.27. At the end of the year,...Ch. 8 - Olympus, Inc., manufactures three models of...Ch. 8 - Refer to Exercise 8.29. Suppose Gene determines...Ch. 8 - Trumbull Co. plans to produce 100,000 toy cars...Ch. 8 - Which of the following describes the order in...Ch. 8 - A companys controller is adjusting next years...Ch. 8 - A companys sales for the coming months are as...Ch. 8 - The budget that adjusts unit sales for beginning...Ch. 8 - Ponderosa, Inc., produces wiring harness...Ch. 8 - Bernard Creighton is the controller for Creighton...Ch. 8 - Greiner Company makes and sells high-quality glare...Ch. 8 - Prob. 39PCh. 8 - The controller for Muir Companys Salem plant is...Ch. 8 - Refer to Problem 8.40 for data. Required: 1. Run a...Ch. 8 - Norton Company, a manufacturer of infant furniture...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- A companys sales for the coming months are as follows: About 20 percent of sales are cash sales, and the remainder are credit sales. The company finds that typically 10 percent of a months credit sales are paid in the month of sale, 70 percent are paid the next month, and 15 percent are paid in the second month after sale. Expected cash receipts in July are budgeted at what amount? a. 114,520 b. 143,150 c. 145,720 d. 156,000arrow_forwardCarmichael Corporation is in the process of preparing next years budget. The pro forma income statement for the current year is as follows: Required: 1. What is the break-even sales revenue (rounded to the nearest dollar) for Carmichael Corporation for the current year? 2. For the coming year, the management of Carmichael Corporation anticipates an 8 percent increase in variable costs and a 60,000 increase in fixed expenses. What is the break-even point in dollars for next year? (CMA adapted)arrow_forwardEastman, Inc., manufactures and sells three products: R, S, and T. In January, Eastman, Inc., budgeted sales of the following. At the end of the year, actual sales revenue for Product R and Product S was 3,075,000 and 3,254,000, respectively. The actual price charged for Product R was 25 and for Product S was 20. Only 10 was charged for Product T to encourage more consumers to buy it, and actual sales revenue equaled 540,000 for this product. Required: 1. Calculate the sales price and sales volume variances for each of the three products based on the original budget. 2. Suppose that Product T is a new product just introduced during the year. What pricing strategy is Eastman, Inc., following for this product?arrow_forward
- The sales department of Macro Manufacturing Co. has forecast sales for its single product to be 20,000 units for June, with three-quarters of the sales expected in the East region and one-fourth in the West region. The budgeted selling price is 25 per unit. The desired ending inventory on June 30 is 2,000 units, and the expected beginning inventory on June 1 is 3,000 units. Prepare the following: a. A sales budget for June. b. A production budget for June.arrow_forwardOne Device makes universal remote controls and expects to sell 500 units in January, 800 in February, 450 in March, 550 in April, and 600 in May. The required ending inventory is 20% of the next months sales. Prepare a production budget for the first four months of the year.arrow_forwardBefore the year began, the following static budget was developed for the estimated sales of 50,000. Sales are higher than expected and management needs to revise its budget. Prepare a flexible budget for 100,000 and 110,000 units of sales.arrow_forward
- Iona Company, a large printing company, is in its fourth year of a five-year, quality improvement program. The program began in 20x0 with an internal study that revealed the quality costs being incurred. In that year, a five-year plan was developed to lower quality costs to 10 percent of sales by the end of 20x5. Sales and quality costs for each year are as follows: Budgeted figures. Quality costs by category are expressed as a percentage of sales as follows: The detail of the 20x5 budget for quality costs is also provided. All prevention costs are fixed; all other quality costs are variable. During 20x5, the company had 12 million in sales. Actual quality costs for 20x4 and 20x5 are as follows: Required: 1. Prepare an interim quality cost performance report for 20x5 that compares actual quality costs with budgeted quality costs. Comment on the firms ability to achieve its quality goals for the year. 2. Prepare a one-period quality performance report for 20x5 that compares the actual quality costs of 20x4 with the actual costs of 20x5. How much did profits change because of improved quality? 3. Prepare a graph that shows the trend in total quality costs as a percentage of sales since the inception of the quality improvement program. 4. Prepare a graph that shows the trend for all four quality cost categories for 20x1 through 20x5. How does this graph help management know that the reduction in total quality costs is attributable to quality improvements? 5. Assume that the company is preparing a second five-year plan to reduce quality costs to 2.5 percent of sales. Prepare a long-range quality cost performance report assuming sales of 15 million at the end of five years. Assume that the final planned relative distribution of quality costs is as follows: proofreading, 50 percent; other inspection, 13 percent; quality training, 30 percent; and quality reporting, 7 percent.arrow_forwardPalmgren Company produces consumer products. The sales budget for four months of the year is presented below. Company policy requires that ending inventories for each month be 25 percent of next months sales. At the beginning of July, the beginning inventory of consumer products met that policy. Required: Prepare a production budget for the third quarter of the year. Show the number of units that should be produced each month as well as for the quarter in total.arrow_forwardLens Junction sells lenses for $45 each and is estimating sales of 15,000 units in January and 18,000 in February. Each lens consists of 2 pounds of silicon costing $2.50 per pound, 3 oz of solution costing $3 per ounce, and 30 minutes of direct labor at a labor rate of $18 per hour. Desired inventory levels are: Â Prepare a sales budget, production budget. direct materials budget for silicon and solution, and a direct labor budget.arrow_forward
- Pilsner Inc. purchases raw materials on account for use in production. The direct materials purchases budget shows the following expected purchases on account: Pilsner typically pays 25% on account in the month of billing and 75% the next month. Required: 1. How much cash is required for payments on account in May? 2. How much cash is expected for payments on account in June?arrow_forwardPlay-Disc makes Frisbee-type plastic discs. Each 12-inch diameter plastic disc has the following manufacturing costs: For the coming year, Play-Disc expects to make 300,000 plastic discs, and to sell 285,000 of them. Budgeted beginning inventory in units is 16,000 with unit cost of 4.75. (There are no beginning or ending inventories of work in process.) Required: 1. Prepare an ending finished goods inventory budget for Play-Disc for the coming year. 2. What if sales increased to 290,000 discs? How would that affect the ending finished goods inventory budget? Calculate the value of budgeted ending finished goods inventory.arrow_forwardCash budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent 50,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of September 1 include cash of 40,000, marketable securities of 75,000, and accounts receivable of 300,000 (60,000 from July sales and 240,000 from August sales). Sales on account for July and August were 200,000 and 240,000, respectively. Current liabilities as of September 1 include 40,000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of 55,000 will be made in October. Bridgeports regular quarterly dividend of 25,000 is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of 50,000. Instructions Prepare a monthly cash budget and supporting schedules for September, October, and November. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT
Fundamentals Of Financial Management, Concise Edi...FinanceISBN:9781337902571Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Fundamentals Of Financial Management, Concise Edi...
Finance
ISBN:9781337902571
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
Responsibility Accounting| Responsibility Centers and Segments| US CMA Part 1| US CMA course; Master Budget and Responsibility Accounting-Intro to Managerial Accounting- Su. 2013-Prof. Gershberg; Author: Mera Skill; Rutgers Accounting Web;https://www.youtube.com/watch?v=SYQ4u1BP24g;License: Standard YouTube License, CC-BY