Gen Combo Fundamentals Of Cost Accounting; Connect Access Card
6th Edition
ISBN: 9781260848700
Author: William N. Lanen Professor, Shannon Anderson Associate Professor, Michael W Maher
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 13, Problem 32E
Estimate Purchases and Cash Disbursements
Midland Company buys tiles and prints different designs on them for souvenir and gift stores. It buys the tiles from a small company in Europe, so at all times it keeps on hand a stock equal to the tiles needed for three months’ sales. The tiles cost $3 each and must be paid for in cash. The company has 28,000 tiles in stock. Sales estimates, based on contracts received, are as follows for the next six months:
Required
- a. Estimate purchases (in units) for January, February, and March.
- b. Estimate cash required to make purchases in January, February, and March.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Midland Company buys tiles and prints different designs on them for souvenir and gift stores. It buys the tiles from a small company in Europe, so at all times it keeps on hand a stock equal to the tiles needed for three months’ sales. The tiles cost $1.00 each and must be paid for in cash. The company has 29,000 tiles in stock. Sales estimates, based on contracts received, are as follows for the next six months:
January
12,300
February
17,600
March
13,400
April
13,200
May
8,700
June
6,300
Required:
a. & b. Estimate purchases (in units) and cash required to make purchases in January, February, and March.
Midland Company buys tiles and prints different designs on them for souvenir and gift stores. It buys the tiles from a small company in Europe, so at all times it keeps on hand a stock equal to the tiles needed for three months’ sales. The tiles cost $3 each and must be paid for in cash. The company has 28,000 tiles in stock. Sales estimates, based on contracts received, are as follows for the next six months:
January
12,400
February
17,800
March
13,200
April
14,200
May
9,600
June
7,200
Required:
a. & b. Estimate purchases (in units) and cash required to make purchases in January, February, and March.
MIDLAND COMPANY
Merchandise Purchases BudgetFor the Period Ended March 31(in units)
January February March
Units to be purchased ? ? ?
Estimated cost ? ? ?
Cash disbursements schedule The Coffee Specialist Corporation has approached you to compile a cash disbursement schedule for the months of March, April, and May. Use the following information to prepare this schedule.Sales: January = $520,000; February = $540,000; March = $550,000; April = $600,000; May = $660,000; June = $670,000Purchases: Purchases are calculated as 70% of the following month’s sales, 50% of purchases are made in cash, 30% of purchases are settled one month after purchase, and the remaining 20% of purchases are settled 2 months after purchase.Rent: The firm pays rent of $9,500 per month.Wages and salaries: The fixed wage and salary costs are $7,500 per month plus a variable cost of 6.5% of the current month’s sales.Taxes: The tax bill to be paid in May amounts to $57,500.Fixed asset outlays: New equipment will be acquired during March at a cost of $85,000.Interest payments: An amount of $32,000 for interest is due in March.Cash dividends: Dividends of $15,000 will be…
Chapter 13 Solutions
Gen Combo Fundamentals Of Cost Accounting; Connect Access Card
Ch. 13 - Prob. 1RQCh. 13 - Prob. 2RQCh. 13 - Prob. 3RQCh. 13 - What role does the master budget play in the...Ch. 13 - What problems might arise if a firm relies solely...Ch. 13 - What is the coordinating role of budgeting?Ch. 13 - Prob. 7RQCh. 13 - Write out the inventory equation that is used to...Ch. 13 - What makes creating budgets for marketing and...Ch. 13 - Prob. 10RQ
Ch. 13 - Preparing a budget is a waste of time. The...Ch. 13 - In the Business Application feature, Using the...Ch. 13 - Prob. 13CADQCh. 13 - Would the budgeting plans for a company that uses...Ch. 13 - Government agencies are limited in spending by...Ch. 13 - What is the difference between the planning and...Ch. 13 - When might the master budget start with a forecast...Ch. 13 - In some organizations (firms, universities,...Ch. 13 - Our cash budget shows a surplus for the quarter,...Ch. 13 - Your boss asks for your estimate on the costs of a...Ch. 13 - The chapter identified four techniques used for...Ch. 13 - Role of Budgets and Plans
Cosmic Corporation is a...Ch. 13 - Human Element in Budgeting
Roller Partners is a...Ch. 13 - Estimate Sales Revenues Stubs-R-Us is a local...Ch. 13 - Estimate Sales Revenues Friendly Financial has 160...Ch. 13 - Estimate Sales Revenues Larson, Inc., manufactures...Ch. 13 - Estimate Production Levels Offenbach Son has just...Ch. 13 - Estimate Sales Levels Using Production Budgets...Ch. 13 - Estimate Inventory Levels Using Production Budgets...Ch. 13 - Estimate Production Levels: Capacity Constraints...Ch. 13 - Prob. 31ECh. 13 - Estimate Purchases and Cash Disbursements Midland...Ch. 13 - Estimate Purchases and Cash Disbursements Lakeside...Ch. 13 - Estimate Cash Disbursements Cascade, Ltd., a...Ch. 13 - Estimate Cash Collections Minot Corporation is...Ch. 13 - Estimate Cash Collections Ewing Company is...Ch. 13 - Estimate Cash Receipts Scare-2-B-U (S2BU)...Ch. 13 - Estimate Cash Receipts Varmit-B-Gone is a pest...Ch. 13 - Prepare Budgeted Financial Statements
Refer to the...Ch. 13 - Prepare Budgeted Financial Statements Cycle-1 is a...Ch. 13 - Prepare Budgeted Financial Statements Carreras Caf...Ch. 13 - Budgeting in a Service Organization Executive...Ch. 13 - Prob. 43ECh. 13 - Prob. 44ECh. 13 - Prob. 45ECh. 13 - Prob. 46ECh. 13 - Sensitivity Analysis Sanjanas Sweet Shoppe...Ch. 13 - Sensitivity Analysis Classic Limo, Inc., provides...Ch. 13 - Prob. 49ECh. 13 - Prob. 50ECh. 13 - Prepare Budgeted Financial Statements The...Ch. 13 - Prob. 52PCh. 13 - Prepare Budgeted Financial Statements Gulf States...Ch. 13 - Prob. 54PCh. 13 - Prob. 55PCh. 13 - Prepare a Production Budget Haggstrom, Inc.,...Ch. 13 - Sales Expense Budget SPU, Ltd., has just received...Ch. 13 - Budgeted Purchases and Cash Flows Mast Corporation...Ch. 13 - Prepare Budgeted Financial Statements HomeSuites...Ch. 13 - Prob. 60PCh. 13 - Comprehensive Budget Plan Brighton, Inc.,...Ch. 13 - Comprehensive Budget Plan Panther Corporation...Ch. 13 - Budgeted Financial Statements in a Retail...Ch. 13 - Cash Budgets and Sensitivity Analysis in a Retail...Ch. 13 - Prob. 66IC
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
- Halifax Shoes has 30% of its sales in cash and the remainder on credit. Of the credit sales, 65% is collected in the month of sale, 25% is collected the month after the sale, and 5% is collected the second month after the sale. How much cash will be collected in August if sales are estimated as $75,000 in June, $65,000 in July, and $90,000 in August?arrow_forwardOn January 1, Sweet Pleasures, Inc., begins business. The company has 14,000 cash on hand and is attempting to project cash receipts and disbursements through April 30. On May 1, a note payable of 10,000 will be due. This amount was borrowed on January 1 to carry the company through its first four months of operation. The unit purchase cost of the companys single product, a box of Sweet Pleasures chocolates, is 12. The unit sales price is 28. Projected purchases and sales in units for the first four months are: Sales terms call for a 5% discount if paid within the same month that the sale occurred. It is expected that 50% of the billings will be collected within the discount period, 25% by the end of the month after purchase, 19% in the following month, and 6% will be uncollectible. Approximately 60% of the purchases are paid for in the month purchased. The rest are due and payable in the next month. Total fixed marketing and administrative expenses for each month include cash expenses of 5,000 and depreciation on equipment of 2,000. Variable marketing and administrative expenses total 6 per unit sold. All marketing and administrative expenses are paid as incurred. REQUIREMENT You have been asked to prepare a cash budget for the next four months to see if the loan can be repaid. Review the worksheet CASHBUD that follows these requirements. The problem data have already been entered in the Data Section of the worksheet.arrow_forwardRanger Industries has provided the following information at June 30: Other information: Average selling price, 196 Average purchase price per unit, 110 Desired ending inventory, 40% of next months unit sales Collections from customers: In month of sale20% In month after sale50% Two months after sale30% Projected cash payments: Inventory purchases are paid for in the month following acquisition. Variable cash expenses, other than inventory, are equal to 25% of each months sales and are paid in the month of sale. Fixed cash expenses are 40,000 per month and are paid in the month incurred. Depreciation on equipment is 2,000 per month. REQUIREMENT You have been asked to prepare a master budget for the upcoming quarter (July, August, and September). The components of this budget are a monthly sales budget, a monthly purchases budget, a monthly cash budget, a forecasted income statement for the quarter, and a forecasted September 30 balance sheet. The worksheet MASTER has been provided to assist you. Ranger Industries desires to maintain a minimum cash balance of 8,000 at the end of each month. If this goal cannot be met, the company borrows the exact amount needed to reach its goal. If the company has a cash balance greater than 8,000 and also has loans payable outstanding, the amount in excess of 8,000 is paid to the bank. Annual interest of 18% is paid on a monthly basis on the outstanding balance.arrow_forward
- Nonnas Re-Appliance Store collects 55% of its accounts receivable in the month of sale and 40% in the month after the sale. Given the following sales, how much cash will be collected in February?arrow_forwardKhloe Company imports gift items from overseas and sells them to gift shops and department stores throughout the United States. Khloe Company provided the following information: The October 31 balance in the cash account is $53,815. All sales are on account. Sales in September were $990,000 and in October were $1,290,000. November sales are expected to be $2,150,000. In Khloe’s experience, 70 percent of sales are collected in the month of sale and 27 percent are collected in the month following sale. The remaining credit sales are uncollectible. Khloe purchases all merchandise on account. Purchases in September were $735,000 and in October were $950,000. November purchases are expected to be $2,020,000 as Khloe prepares for the Christmas buying season. Fifteen percent of purchases are paid in the month of purchase, while the remainder is paid in the month following the purchase month. Khloe Company has nine employees who are paid a total of $45,000 per month. Due to timing issues,…arrow_forwardA CARDBOARD BOX FACTORY pays its suppliers 40 days after making the purchase and receiving the goods. The average collection period is 45 days, i.e. its customers settle their debt with the company in that time; and the average inventory age is based on the inventory turnover which is 10 times a year. The company spends about $1.23 million in operating cycle investments. With this data we need to calculate: The operating cycle.The cash conversion cycle.The cash turnover.The minimum cash balance.You plan to make modifications to your policies so that you can decrease your PPC by 10 days, and decrease your EPI by 2 times (before converting it to days). Negotiations with your supplier have been unsuccessful and the payment term has been reduced by 10 days. With these data you have to calculate: Re-calculate the Operating Cycle, the SCC, RC and SMC introducing the proposed changes.Calculate the opportunity cost that the changes will cause, if the company's interest rate is 8%.arrow_forward
- Ballentine Company expects sales for June, July, and August of $65,000, $71,000, and $61,000, respectively. Experience suggests that 40% of sales are for cash and 60% are on credit. The company collects 55% of its credit sales in the month following sale, 40% in the second month following sale, and 5% are not collected. What are the company's expected cash receipts for August from its current and past sales? Multiple Choice $39,030. $63,430. $81,600. $89,450. $118,200.arrow_forwardHalifax Shoes has 30% of its sales in cash and the remainder on credit. Of the credit sales, 65% is collected in the month of sale, 25% is collected the month after the sale, and 5% is collected the second month after the sale. How much cash will be collected in August if sales are estimated as $74,000 in June, $68,000 in July, and $88,000 in August? Cash collected $fill in the blank 1arrow_forwardchedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 20% pay their accounts in the month of sale, while the remaining 80% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $115,000 November 144,000 December 210,000 The Accounts Receivable balance on September 30 was $77,000. Prepare a schedule of cash collections from sales for October, November, and December. Round all calculations to the nearest whole dollar. OfficeMart Inc. Schedule of Cash Collections from Sales For the Three Months Ending December 31 October November December Receipts from cash sales: Cash sales $ $ $ September sales on account: Collected in October October sales on account:…arrow_forward
- Eddie's Bar and Restaurant Supplies expects its revenues and payments for the first part of the year to be: Sales Purchases January $14,000 $18,000 February 20,000 21,300 March 26,000 19,100 April 22,000 22,400 May 18,000 14,700 Seventy percent of the firm's sales are on credit. Past experience shows that 40 percent of accounts receivable are collected in the month after sale, and the remainder is collected in the second month after sale. Prepare a schedule of cash receipts for March, April and May. Eddie's pays its payments in the following month. Eddie's had a cash balance of $2,000 on March 1, which is also its minimum required cash balance. There is an outstanding loan of $2,000 on March 1. Prepare a cash budget for March, April, and May. Can you provide the excel formulas used so then I can do it myself and learn as well, please.arrow_forwardddie's Bar and Restaurant Supplies expects its revenues and payments for the first part of the year to be: Sales Purchases Jan. $14,000 $81,000 Feb. 20,000 21,300 Mar. 26,000 19,100 April. 22,000 22,400 May 18,000 14,700 Seventy percent of the firm's sales are on credit. Experience shows that 40 percent of accounts receivable are collected in the month after sale, and the remainder are collected in the second month after sale. Prepare a schedule of cash receipts for March, April, and May. Eddie's pays its payments in the following month. Eddie's had a cash balance of $2,000 on March 1, which is also its minimum required cash balance. There is an outstanding loan of $2,000 on March 1. Prepare a cash budget for March, April, and May.arrow_forwardA Company's credit sales policy is to have: 50% of the sales amount in cash 30% collected after one month 20% after two months. The purchasing policy is to pay 60% in cash and the rest is to be paid after one month. Required: Calculate the net accounting profit for December. Calculate the net cash flow for December. Comment on the difference between the two previous answers. Item October November December Sales 400,000 350,000 450,000 Purchases 350,000 340,000 420,000arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
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