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
Question
Chapter 9, Problem 9.15SE
1.
To determine
To prepare: The sales budget for January and February.
2.
To determine
To prepare: The Company’s cost of goods sold, inventory, and purchases budget for January and February.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
(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?
Johnston Bookstore is the bookstore on campus for students and faculty. The bookstore
E9-18A Sales budget for a retail organization (Learning Objective 2)
shows the following sales projections in units by quarter for the upcoming year
School Supplies
Apparel
Miscellaneous
Quarter
Books
1,570
200
580
690
1st.
.....
2nd
800
190
330
540
3rd
1,790
240
880
890
4th
670
180
540
440
The average price of an item in each of the departments is as follows:
Average sales price per unit
Books..
$85
School supplies
Apparel..
Miscellaneous.
$18
$29
$ 6
Requirement
Prepare a sales budget for the upcoming year by quarter for the Johnston Bookstore,
with sales categorized by the four product groupings (books, school supplies, apparel,
and miscellaneous).
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.…
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
- Learning Objective 5 Sales Manufacturing costs Selling and administrative expenses Capital expenditures 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 $9,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 $48,000, marketable securities of $68,000, and accounts receivable of $139,000 ($30,000 from July sales and $109,000 from August sales). Sales on account for July and August were $100,000 and $109,000, respectively. Current liabilities as of September 1…arrow_forwardE9-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.arrow_forwardLearning 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…arrow_forward
- 1. Question Content Area Direct Materials Purchases Budget FlashKick Company manufactures and sells soccer balls for teams of children in elementary and high school. FlashKick’s best-selling lines are the practice ball line (durable soccer balls for training and practice) and the match ball line (high-performance soccer balls used in games). In the first four months of next year, FlashKick expects to sell the following: Practice Balls Match Balls Units Selling Price Units Selling Price January 49,000 $8.50 6,900 $17.30 February 60,000 $8.50 7,500 $17.30 March 88,000 $8.50 12,000 $17.30 April 115,000 $8.50 17,000 $17.30 FlashKick requires ending inventory of product to equal 20 percent of the next month’s unit sales. Beginning inventory in January was 9,800 practice soccer balls and 1,380 match soccer balls. Every practice ball requires 0.7 square yard of polyvinyl chloride panels, one bladder with valve (to fill with air), and 2…arrow_forwardYou have a budget to purchase 1,000 sweatshirts for your department. Based on last year’s sales, you have compiled the percentage of planned sales that you will need to purchase for each color that follows. Calculate the number of sweatshirts in each color that you will purchase. Color Percentage of Total Purchases Black 50% White 20% Gray 20% Brown 10%arrow_forwardHomework Saved Help Walton Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Walton's policy is to maintain an ending inventory balance equal to 20 percent of the following month's cost of goods sold. April's budgeted cost of goods sold is $78,000. Required a. Complete the inventory purchases budget by filling in the missing amounts. b. Determine the amount of cost of goods sold the company will report on its first quarter pro forma income statement. c. Determine the amount of ending inventory the company will report on its pro forma balance sheet at the end of the first quarter. Complete this question by entering your answers in the tabs below. Req A Req B and C Complete the inventory purchases budget by filling in the missing amounts. Inventory Purchases Budget January February March Budgeted cost of goods sold 54,000 $ 58,000 $ 64,000 11,600 Inventory needed 65,600 10,800 Required purchases (on…arrow_forward
- 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…arrow_forwardGiven the following information, prepare an annual income statement budget for the Great Student Corporation as of 12/31/2018. 1. Sales: 1000 Units; Price $1,000 per Unit 2. Cost of Goods Sold (COGS): 60% of Sales 3. Wages: 15 Employees; Average Cost per Employee $15000 4. SGA Expenses: 12% of Sales 5. Depreciation: Straight Line $4000 per year 6. Interest Expense: 1% of Sales What was the company's budgeted gross profit? O A. $403,000 O B. $400,000 O C. $41,000 O D. $359,000arrow_forwardInstruction: I want you to prepare a production budget of Learning is Fun Company with the provided information below. Learning is Fun Company forecasts sales in units for January to May as follows: Jan Feb Mar Apr 2,800 May 3,000 Units 2,000 2,200 2,500 Additional Information: • The Company would like to maintain 100 units in its ending inventory at the end of each month. • Beginning inventory at the start of January amounts to 50 units.arrow_forward
- Activate Use free at Ottice.com Lesson 5: Budgeting Calculate the average monthly expenses for these individuals. Kelsey spent $350 in May, $432 in June and $420 in July. Her average monthly expenses are: 2. Michael spent $700 in April and May and $800 in June and July. His average monthly expenses are: State whether these are fixed expenses or variable expenses: 3. Rent: 4. Car Loan: 5. Grocery Bill: 6. Gas Money: 7. School Loan: 8. Shopping Money: 9. Calculate the budget: Car Loan $255 Rent $275 Utilities $300 Grocery $150 Other $200 Total:arrow_forwardAt the beginning of the school year, Priscilla Wescott decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget: Cash balance, September 1 (from a summer job) $6,000 Purchase season football tickets in September 150 Additional entertainment for each month 250 Pay fall semester tuition in September 3,500 Pay rent at the beginning of each month 450 Pay for food each month 400 Pay apartment deposit on September 2 (to be returned December 15) 450 Part-time job earnings each month (net of taxes) 1,300 Question Content Area a. Prepare a cash budget for September, October, November, and December. Enter all amounts as positive values except cash decrease which should be indicated with a minus sign. Priscilla WescottCash BudgetFor the Four Months Ending…arrow_forwardQ1. Joanne Company shows the following estimates for sales for the third quarter of its upcoming fiscal year: July August September Q3 Sales 15000 14000 13500 The company requires inventory on hand equal to 15% of the next month’s expected sales. The company expects to begin July with 10000 units in inventory. The expected sales for October are 16,000. Prepare the production budget. Q2. Nutri Drinks Inc. makes a nutrition additive for store bought soft drinks and expects to sell 4,000 units in January, 9,000 in February, 3,500 in March, 5,700 in April, and 4,900 in May. The required ending inventory is 15% of the next month’s sales, and the beginning inventory on January 1 was 0 units. Prepare a production budget for the first four months of the year. Q3. The Sleep Well Company sells custom airplane sleeping accessories for $215 each. It expects sales of 5,000 units in quarter 1 and a 15% increase each subsequent quarter for the next 4 quarters.…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