Managerial Accounting (5th Edition)
5th Edition
ISBN: 9780134128528
Author: Karen W. Braun, Wendy M. Tietz
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 9, Problem 9.57AP
Comprehensive budgeting problem (Learning Objectives 2 & 3)
Martin Manufacturing is preparing its
Current Assets as of December 31 (prior year): | |
Cash | $ 4.500 |
$ 47,000 |
Inventory | $ 15,700 |
Property, plant, and equipment, net | $120,000 |
Accounts payable | $ 42,400 |
Capital stock | $124,000 |
$23,100 |
- a. Actual sales in December were $70,000. Selling price per unit is projected to remain stable at $10 per unit throughout the budget period. Sales for the first five months of the upcoming year are budgeted to be as follows:
January | $ 80,000 |
February | $ 92,000 |
March | $ 99,000 |
April | $ 97,000 |
May | $ 85,000 |
- b. Sales are 30% cash and 70% credit. All credit sales are collected in the month following the sale.
- c. Martin Manufacturing has a policy stating that each month’s ending inventory of finished goods should be 25% of the following month’s sales (in units).
- d. Of each month’s direct materials purchases, 20% are paid for in the month of purchase, while the remainder is paid for in the month following purchase. Two pounds of direct material is needed per unit at $2 per pound. Ending inventory of direct materials should be 10% of next month’s production needs.
- e. Most of the labor at the manufacturing facility is indirect, but there is some direct labor incurred. The direct labor hours per unit is 0.01. The direct labor rate per hour is $12 per hour. All direct labor is paid for in the month in which the work is performed. The direct labor total cost for each of the upcoming three months is as follows:
January | $996 |
February | $1,125 |
March | $1,182 |
- f. Monthly manufacturing
overhead costs are $5,000 for factory rent, $3,000 for other fixed manufacturing expenses, and $1.20 per unit for variable manufacturing overhead. No depreciation is included in these figures. All expenses are paid in the month in which they are incurred. - g. Computer equipment for the administrative offices will be purchased in the upcoming quarter. In January, Martin Manufacturing will purchase equipment for $5,000 (cash), while February’s cash expenditures will be $12,000 and March’s cash expenditures will be $16,000.
- h. Operating expenses are budgeted to be $1.00 per unit sold plus fixed operating expenses of $1,000 per month. All operating expenses are paid in the month in which they are incurred. No depreciation is included in these figures.
- i. Depreciation on the building and equipment for the general and administrative offices is budgeted to be $4,600 for the entire quarter, which includes depreciation on new acquisitions.
- j. Martin Manufacturing has a policy that the ending cash balance in each month must be at least $4,000. It has a line of credit with a local bank. The company can borrow in increments of $1,000 at the beginning of each month, up to a total outstanding loan balance of $150,000. The interest rate on these loans is 1% per month simple interest (not compounded). The company would pay down on the line of credit balance in increments of $1,000 if it has excess funds at the end of the quarter. The company would also pay the accumulated interest at the end of the quarter on the funds borrowed during the quarter.
- k. The company’s income tax rate is projected to be 30% of operating income less interest expense. The company pays $10,000 cash at the end of February in estimated taxes.
Requirements
- 1. Prepare a schedule of cash collections for January, February, and March, and for the quarter in total. Use the following format:
9.4-49 Full Alternative Text
- 2. Prepare a production budget, using the following format:
9.4-50 Full Alternative Text
*Hint: Unit sales = Sales in dollars/Selling price per unit
- 3. Prepare a direct materials budget, using the following format:
9.4-51 Full Alternative Text
- 4. Prepare a cash payments budget for the direct material purchases from Requirement 3, using the following format. (Use the accounts payable balance at December 31 of prior year for the prior month payment in January.)
9.4-52 Full Alternative Text
- 5. Prepare a cash payments budget for direct labor, using the following format:
9.4-53 Full Alternative Text
- 6. Prepare a cash payments budget for manufacturing overhead costs, using the following format:
9.4-54 Full Alternative Text
- 7. Prepare a cash payments budget for operating expenses, using the following format:
9.4-55 Full Alternative Text
- 8. Prepare a combined
cash budget , using the following format:
9.4-56 Full Alternative Text
- 9. Calculate the budgeted
manufacturing cost per unit, using the following format (assume that fixed manufacturing overhead is budgeted to be $0.80 per unit for the year):
9.4-57 Full Alternative Text
- 10. Prepare a
budgeted income statement for the quarter ending March 31, using the following format:
9.4-58 Full Alternative Text
*Hint: Cost of goods sold = Budgeted cost of manufacturing one unit × Number of units sold
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
E9-26A Budgeted income statement (Learning Objective 2)
Delta Labs performs a specialty lab test for local companies for $45 per test. For the
upcoming quarter, Delta Labs is projecting the following sales:
January
February
March
Number of lab tests
5,600
4,900
5,700
The budgeted cost of performing each test is $21. Operating expenses are projected to
be $59,000 in January, $57,000 in February, and $58,000 in March. Delta Labs is subject
to a corporate tax rate of 30%.
Requirement
Prepare a budgeted income statement for the first quarter, with a column for each month
and for the quarter.
BUS 203: INTRODUCTION TO COST AND MANAGEMENT ACCOUNTING PROJECT: CASH BUDGETING ASSOCIATE DEGREE YEAR 2: SEMESTER 1 (2020/21)Ronstadt Limited’s budget for the four months from January to April includes the following data:1. MonthSalesMaterialsWagesOverheads
$000$000$000$000January615115.030360February636120.033390March690135.036420April684130.040425
2. One-third of sales revenue is received one month after sale and the remainder is received two months after sale. The sales in the previous two months were: November $600 000; December $540 000.3. One-quarter of purchases of materials are paid for in the month of purchase. The remainder are paid for two months later. Purchases in the previous two months were: November $108 000; December $106 000.4. Two-thirds of the wages are paid in the month in which they are earned, and the balance is paid in the following month. The wages for the previous December amounted to $30 000.5. One-half of the overhead expenditure is paid in the month in…
Learning Objective 2
Product Costs and Product Profitability Reports, using a Single Plantwide Factory Overhead Rate
Isaac Engines Inc. produces three products-pistons, valves, and cams-for the heavy equipment
industry. Isaac Engines has a very simple production process and product line and uses a single
plantwide factory overhead rate to allocate overhead to the three products. The factory overhead
rate is based on direct labor hours. Information about the three products for 20Y2 is as follows:
Pistons
Valves
Cams
Budgeted
Volume
(Units)
6,000
13,000
1,000
Pistons
Direct Labor
Hours Per Unit
Valves
Cams
If required, round all per unit answers to the nearest cent.
a. Determine the plantwide factory overhead rate.
$
28 ✔per dlh
0.30
0.50
0.10
0.3 ✔ dlh
The estimated direct labor rate is $20 per direct labor hour. Beginning and ending inventories are
negligible and are, thus, assumed to be zero. The budgeted factory overhead for Isaac Engines is
$235,200.
0.5 dlh
0.1 ✓dlh
Price Per
Unit…
Chapter 9 Solutions
Managerial Accounting (5th Edition)
Ch. 9 - (Learning Objective 1) Which term describes the...Ch. 9 - (Learning Objective 1) Benefits of budgeting...Ch. 9 - Prob. 3QCCh. 9 - Prob. 4QCCh. 9 - Prob. 5QCCh. 9 - Prob. 6QCCh. 9 - Prob. 7QCCh. 9 - Prob. 8QCCh. 9 - Prob. 9QCCh. 9 - Prob. 10QC
Ch. 9 - Short Exercises S9-1 Order of preparation and...Ch. 9 - Explain why companies use zero-based budgeting...Ch. 9 - Understanding key terms and definitions (Learning...Ch. 9 - Sales Budget (Learning Objective 2) Jefferson...Ch. 9 - Production budget (Learning Objective 2) Nichols...Ch. 9 - Direct materials budget (Learning Objective 2)...Ch. 9 - Prob. 9.7SECh. 9 - Prob. 9.8SECh. 9 - Prob. 9.9SECh. 9 - Prob. 9.10SECh. 9 - Prob. 9.11SECh. 9 - Cash payments budget (Learning Objective 3) Finley...Ch. 9 - Cash budget (Learning Objective 3) SaveCo...Ch. 9 - Prob. 9.14SECh. 9 - Prob. 9.15SECh. 9 - Identify ethical standards violated (Learning...Ch. 9 - Prob. 9.17AECh. 9 - Sales budget for a retail organization (Learning...Ch. 9 - Prob. 9.19AECh. 9 - Production budget (Learning Objective 2) Hoffman...Ch. 9 - Direct materials budget (Learning Objective 2)...Ch. 9 - Production and direct materials budgets (Learning...Ch. 9 - Direct labor budget (Learning Objective 2)...Ch. 9 - Manufacturing overhead budget (Learning Objective...Ch. 9 - Operating expenses budget and an income statement...Ch. 9 - Budgeted income statement (Learning Objective 2)...Ch. 9 - Prob. 9.27AECh. 9 - Cash collections budget (Learning Objective 3)...Ch. 9 - Cash payments budget (Learning Objective 3) The...Ch. 9 - Prob. 9.30AECh. 9 - Prob. 9.31AECh. 9 - Budgeted balance sheet (Learning Objective 3) Use...Ch. 9 - Prob. 9.33AECh. 9 - Prob. 9.34AECh. 9 - Cost of goods sold, inventory, and purchases...Ch. 9 - Cost of goods sold, inventory, and purchases...Ch. 9 - Prob. 9.37BECh. 9 - Prob. 9.38BECh. 9 - Prob. 9.39BECh. 9 - Prob. 9.40BECh. 9 - Direct materials budget (Learning Objective 2) Moe...Ch. 9 - Prob. 9.42BECh. 9 - Prob. 9.43BECh. 9 - Manufacturing overhead budget (Learning Objective...Ch. 9 - Prob. 9.45BECh. 9 - Prob. 9.46BECh. 9 - Prob. 9.47BECh. 9 - Prob. 9.48BECh. 9 - Prob. 9.49BECh. 9 - Combined cash budget (Learning Objective 3)...Ch. 9 - Sales and cash collections budgets (Learning...Ch. 9 - Prob. 9.52BECh. 9 - Prob. 9.53BECh. 9 - Prob. 9.54BECh. 9 - Prob. 9.55BECh. 9 - Prob. 9.56BECh. 9 - Comprehensive budgeting problem (Learning...Ch. 9 - Cash budgets under two alternatives (Learning...Ch. 9 - Comprehensive summary problem (Learning Objectives...Ch. 9 - Prob. 9.60APCh. 9 - Cash budgets (Learning Objective 3) Elis...Ch. 9 - Prob. 9.62APCh. 9 - Cost of goods sold, inventory, and purchases...Ch. 9 - Prob. 9.64APCh. 9 - Problems Group B P9-65B Comprehensive budgeting...Ch. 9 - Cash budgets under two alternatives (Learning...Ch. 9 - Comprehensive summary problem (Learning Objectives...Ch. 9 - Prob. 9.68BPCh. 9 - Cash budgets (Learning Objective 3) Ivans...Ch. 9 - Combined cash budget and a budgeted balance sheet...Ch. 9 - Prob. 9.71BPCh. 9 - Prepare comprehensive budgets for a retailer...Ch. 9 - Prob. 9.73SCCh. 9 - Discussion Questions 1. The sales budget is the...Ch. 9 - Budgeting for a Single Product In this activity,...Ch. 9 - Ethics and budgetary slack (Learning Objectives 1,...Ch. 9 - Prob. 9.77ACT
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
- Prepare Hilton goods sold computations. 2. Prepare a combined cash budget similar to exhibits in the chapter. If no financing ac- P9-61A Cash budgets (Learning Objective 3) and cash disbursements: are as follows: Budgeted Sales Revenue $62,000 January $70,000 February. b. Actual purchases of direct materials in December were $24,500. The companye purchases of direct materials in January are budgeted to be $24,000 and $26.000 i February. All purchases are paid 40% in the month of purchase and 60% the follow month. c. Salaries and sales commissions are also paid half in the month earned and half the next month. Actual salaries were $8,000 in December. Budgeted salaries in Janu- ary are $9,000 and February budgeted salaries are $10,500. Sales commissions each month are 8% of that month's sales. d. Rent expense is $3,500 per month. e. Depreciation is $2,100 per month. f. Estimated income tax payments are made at the end of January. The estimated tax payment is projected to be $12,500. g.…arrow_forwardIn Organizational Development (OD), each area of OD has its own budget to maintain. Please create a spreadsheet indicating the following purchases for the different OD areas and the remaining balance for each department based on the beginning budget and purchases as indicated. The Center for the Advancement of Teaching and Learning Beginning Budget $60,000 Speaker Books Speaker Gifts $2,000 100 @ $22.50 each $200.00 Leadership Development Beginning Budget $40,000 Retreat Location Rental Retreat Lunch Conference Awards $8,000 $11.00 each for 72 attendees $9,000 $8,800 Creative and Strategic Initiatives Beginning Budget $25,000 Camera Software Digital subscriptions $7,000 $2,000 $550.00arrow_forwardes The management of Mecca Copy, a photocopying center located on University Avenue, has compiled the following data to use in preparing its budgeted balance sheet for next year: Cash Accounts receivable Supplies inventory Equipment Accumulated depreciation Accounts payable Common stock Retained earnings Ending Balances ? $ 9,200 $ 2,800 $ 39,500 $ 16,000 Current assets: $ 2,900 $ 5,000 ? The beginning balance of retained earnings was $28,000, net income is budgeted to be $17,800, and dividends are budgeted to be $3,700. Required: Prepare the company's budgeted balance sheet. (Amounts to be deducted should be indicated by a minus sign.) Mecca Copy Budgeted Balance Sheet Assetsarrow_forward
- Relevant data from the Poster Companys operating budgets are: Additional data: Capital assets were sold in January for $10,000 and $4,500 in May. Dividends of $4,500 were paid in February. The beginning cash balance was $60,359 and a required minimum cash balance is $59,000. Use this information to prepare a cash budget for the first two quarters of the yeararrow_forwardRequired Information TES-417 Inc. is a retaller. Its accountants are preparing the company's 2nd quarter master budget. The company has the following balance sheet as of March 31. TES-417 Inc. Balance Sheet March 31 Assets Accounts receivable Inventory 129,880 52, see 217,000 Plant and equipment, net of depreciation. Total assets $ 480.500 Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings 55, see Total liabilities and stockholders' equity $ 480.500 TES-417 accountants have made the following estimates: 1. Sales for April, May, June, and July will be $280,000, $300,000, $290,000, and $310,000, respectively. 2. All sales are on credit. Each month's credit sales are collected 35% in the month of sale and 65% in the month following the sale. All of the accounts receivable at March 31 will be collected in April. 3. Each month's ending inventory must equal 25% of next month's cost of goods sold. The cost of goods sold is 75% of sales. The company pays for…arrow_forwardMecca Copy, a photocopying center located on University Avenue, provided the following data to prepare a budgeted balance sheet for next year: Ending Balances eBook Hint Print Cash Accounts receivable Supplies inventory Equipment Accumulated depreciation Accounts payable Common stock Retained earnings ? $ 8,100 $ 3,200 $ 34,000 $ 16,000 $ 1,800 $ 5,000 ? The beginning balance of retained earnings was $28,000, budgeted net income is $11,500, and budgeted dividends are $4,800. Required: Prepare the company's budgeted balance sheet. Note: Amounts to be deducted should be indicated by a minus sign.arrow_forward
- Applying Excel: Master Budgeting Beech Corporation is a master budget for the 3rd quarter of the calendar year. The company’s balance sheet is shown below: June Corporation Balance Sheet June 30 Assets Cash $ 90,000 Accounts receivable 136,000 Inventory 62,000 Building + equipment, net of depreciation 210,000 Total assets $498,000 Liability and Stockholder’s Equity Accounts payable $ 71,100 Common stock 327,000 Retained earnings 99,900 Total liability and stockholder’s equity $498,000 Beech’s managers have made the following assumptions and estimates: Estimated sales for July, August, September, and October will be $210,000, $230,000, $220,000, and $240,000 respectively. All sales are credit and all credit sales are collected. (Note: there are no cash sales). Thirty-five percent (35%) the month’s credit sales are collected in the month the sales are made, and the remaining 65% is collected the…arrow_forwardCheck my work The management of Mecca Copy, a photocopying center located on University Avenue, has compiled the following data to use in preparing its budgeted balance sheet for next year: Ending Balances ? $ 8,100 Cash Accounts receivable Supplies inventory Equipment $ 3,200 $ 34,000 Accumulated depreciation $ 16,000 $ 1,800 $ 5,000 ? Accounts payable Common stock Retained earnings The beginning balance of retained earnings was $28,000, net income is budgeted to be $11,500, and dividends are budgeted to be $4,800. Required: Prepare the company's budgeted balance sheet. (Amounts to be deducted should be indicated by a minus sign.) Mecca Copy Budgeted Balance Sheet Assets Current assets: Total current assetsarrow_forward(Learning Objective 5: Use the COGS model to make management decisions)Spicer Industries prepares budgets to help manage the company. Spicer is budgeting forthe fiscal year ended January 31, 2018. During the preceding year ended January 31, 2017,sales totaled $9,700 million and cost of goods sold was $6,400 million. At January 31, 2017,inventory was $1,500 million. During the upcoming 2018 year, suppose Spicer expects costof goods sold to increase by 12%. The company budgets next year’s ending inventory at$1,800 million.Requirement1. One of the most important decisions a manager makes is how much inventory to buy. Howmuch inventory should Spicer purchase during the upcoming year to reach its budget?arrow_forward
- Required: 1. Prepare a schedule of expected cash collections for July, August, and September. 1. Cash Collections for Q3 July August September Q3 From A/R From July sales From Aug sales From Sep sales Total cash collectionsarrow_forwardRequired information [The following information applies to the questions displayed below.] Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company's balance sheet as of June 30th is shown below: Beech Corporation Balance Sheet June 30 Assets Cash Accounts receivable Inventory Plant and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity $ 94,000 145,000 59,400 222,000 $520,400 $ 83,000 331,000 106,400 $ 520,400 Beech's managers have made the following additional assumptions and estimates: 1. Estimated sales for July, August, September, and October will be $330,000 $350,000, $340,000, and $360,000, respectively. 2. All sales are on credit and all credit sales are collected. Each month's credit sales are collected 35% in the month of sale and 65% in the month following the sale. All of the…arrow_forwardRequired information [The following information applies to the questions displayed below.] Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company's balance sheet as of June 30th is shown in the picture provided: Beech's managers have made the following additional assumptions and estimates: Estimated sales for July, August, September, and October will be $360,000, $380,000, $370,000, and $390,000, respectively. All sales are on credit and all credit sales are collected. Each month's credit sales are collected 35% in the month of sale and 65% in the month following the sale. All of the accounts receivable at June 30 will be collected in July. Each month's ending inventory must equal 25% of the cost of next month's sales. The cost of goods sold is 60% of sales. The company pays for 40% of its merchandise purchases in the month of the purchase and the remaining 60% in the month following the purchase. All of…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
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