Fundamentals Of Cost Accounting (6th Edition)
6th Edition
ISBN: 9781259969478
Author: WILLIAM LANEN, Shannon Anderson, Michael Maher
Publisher: McGraw Hill Education
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 13, Problem 41E
Prepare Budgeted Financial Statements
Carreras Café is a Spanish restaurant in a college town. The owner expects that the number of meals served in June will be 40 percent below those served in May, because so many students leave for the summer. In May, the restaurant served 4,200 meals at an average price of $15.00. In the summer (June through August), the average price of a meal typically increases by 25 percent and the average food cost of a meal increases by 10 percent. Other costs are typically unchanged during the summer. The following cost information is available for May.
Required
Prepare a
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Carreras Café is a Spanish restaurant in a college town. The owner expects that the number of meals served in June will be 40 percent below those served in May, because so many students leave for the summer. In May, the restaurant served 4,200 meals at an average price of $20. In the summer (June through August), the average price of a meal typically increases by 30 percent and the average food cost of a meal increases by 15 percent. Other costs are typically unchanged during the summer. The following cost information is available for May.
Service costs (variable with respect to meals)
Variable service costs (with respect to meals)
Food costs
$
10,200
Labor
16,800
Other variable costs
5,900
Fixed service costs
9,300
Total service costs
$
42,200
Marketing and administrative costs
Marketing (variable with respect to meals)
6,400
Administrative (fixed)
4,900
Total marketing and administrative costs
$
11,300
Total costs
$
53,500…
Please help
Prepare an annual budget for the fiscal year
Chapter 13 Solutions
Fundamentals Of Cost Accounting (6th Edition)
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
- Analyze Johnson Stores staffing budget for holidays Johnson Stores is planning its staffing for the upcoming holiday season. From past history, the store determines that it needs one additional sales clerk for each 12,000 in daily sales. The average daily sales is anticipated to increase by 96,000 from Black Friday until Christmas Eve, or 27 shopping days. Each additional sales clerk will work an eight-hour shift and will be paid 14 per hour. A. Determine the amount to budget for additional sales clerks for the holiday season. B. If Johnson Stores has an average 40% gross profit on sales, should it add the staff suggested by your answer in (A)? That is, is it profitable to staff for the increased sales in (A)?arrow_forwardShalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the follow sales: In Shalimars 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 Shalimars 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.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
- 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_forwardPilsner 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_forwardRehydrator makes a nutrition additive and expects to sell 3,000 units in January, 2,000 in February, 2,500 in March, 2,700 in April. and 2,900 in May. The required ending inventory is 20% of the next months sales, and the beginning inventory on January 1 was 600 units. Prepare a production budget for the first four months of the year.arrow_forward
- CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2019 and 2020: Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale, 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depreciation charges are 36,000 a month. Miscellaneous expenses are 2,700 a month. Income tax payments of 63,000 are due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2019. b. Prepare monthly estimates of the required financing or excess fundsthat is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 1/30 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal, and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if all financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain.arrow_forwardCash budget The controller of Mercury Shoes 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, 60% are expected to be collected in the month following the sale and the remainder the following month (second month after sale). Depreciation, insurance, and property tax expense represent 12,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in February, and the annual property taxes are paid in November. 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 June 1 include cash of 42,000, marketable securities of 25,000, and accounts receivable of 198,000 (150,000 from May sales and 48,000 from April sales). Sales on account in April and May were 120,000 and 150,000, respectively. Current liabilities as of June 1 include 13,000 of accounts payable incurred in May for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of 24,000 will be made in July. Mercury Shoes regular quarterly dividend of 15,000 is expected to be declared in July and paid in August. Management desires to maintain a minimum cash balance of 40,000. Instructions Prepare a monthly cash budget and supporting schedules for June, July, and August. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?arrow_forwardGarden Sales, Incorporated, sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: Budgeted monthly absorption costing income statements for April–July are: April May June July Sales $ 600,000 $ 900,000 $ 500,000 $ 400,000 Cost of goods sold 420,000 630,000 350,000 280,000 Gross margin 180,000 270,000 150,000 120,000 Selling and administrative expenses: Selling expense 79,000 120,000 62,000 51,000 Administrative expense* 45,000 52,000 41,000 38,000 Total selling and administrative expenses 124,000 172,000 103,000 89,000 Net operating income $ 56,000 $ 98,000 $ 47,000 $ 31,000 *Includes $20,000 of depreciation each month. Sales are 20% for cash and 80% on account. Sales on account are…arrow_forward
- Garden Sales, Incorporated, sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: Budgeted monthly absorption costing income statements for April–July are: April May June July Sales $ 600,000 $ 900,000 $ 500,000 $ 400,000 Cost of goods sold 420,000 630,000 350,000 280,000 Gross margin 180,000 270,000 150,000 120,000 Selling and administrative expenses: Selling expense 79,000 120,000 62,000 51,000 Administrative expense* 45,000 52,000 41,000 38,000 Total selling and administrative expenses 124,000 172,000 103,000 89,000 Net operating income $ 56,000 $ 98,000 $ 47,000 $ 31,000 *Includes $20,000 of depreciation each month. Sales are 20% for cash and 80% on account. Sales on account are…arrow_forwardMarthaler's Suits is looking for assistance with preparing a sales and cash receipts budget for the upcoming year. Dan, thve owner, provides you with the following information • The average suit sells for $575. 1,500 suits were sold in December. Expected sales 1600 in January, 1.800 in February, and 1,700 in March. . Cash sales are expected to be 15% and the rest to be on credit. Of the credit sales, 40% are expected to be collected in the month of sale and the rest in the month following the sale. • Cash payments are expected to be paid all on credit, 55% are expected to be paid in the month of purchase and the rest in the month following the purchase. 1. Create a sales budget for Marthaler's Suits for Q1. Sales Budget January February March Quantity Price Total Sales 2. Create the cash receipts budget for Marthaler's Suits for Q1. Cash Receipts Budget March February January Cash Sales Credit Sales Cash Collection of Credit Sales of Current Month Sales of Prior Month Salesarrow_forwardPeters Products, a distributor of organic beverages, needs a cash budget for September. The following information is available: The cash balance at the beginning of August is 9,000€. Contribution margin is 50% (COGS are 50% of sales) Actual sales for July and expected sales for August, September and October are as shown below. Some customers pay in cash (Cash sales) and others in account as described in the figure below. Customers that pay in account, make the payment the month after. Purchases of inventory (company just resells what they buy) must be done so that the end of month inventory must cover 20% of next month sales. Initial inventory in July was 5.300€. 100% of a month’s inventory purchases are paid for during the month of purchase. Prepare a schedule of expected cash collections for August, September & October. Prepare a merchandise purchases budget for July, August, and September. Prepare a schedule of expected cash flow (cash in minus cash out) for August, and…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 Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
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