Concept explainers
Refer to the information pertaining to Endless Mountain Company that is provided in Integration Exercise 8 as well as the schedules that you prepared in answering Integration Exercises 8 through 11.
Required:
1. Assume that the company expects to collect all of its credit sales in the quarter of sale rather than the original assumption that it will collect 75% of credit sales in the quarter of sale and the remaining 25% in the subsequent quarter. Without changing any of the underlying assumptions in your budgeting assumptions tab, calculate the following revised figures
related to the 2017 budget:
a. Net income (absorption basis).
b.
c. Net cash provided by operating activities.
2. Go to the Budgeting Assumptions tab in your Microsoft Excel worksheet. Change the percentage of sales that are collected in the quarter of sale to 100% and the percentage of sales that are collected in the quarter after sale to 0%. Do your answers to la through 1c match the numbers that appear in your Excel worksheet? If not. why?
3. Refer to the original budgeting assumptions from Integration Exercise 8. Assume that the company expects to pay its direct laborers $19 per hour instead of the original estimate of $ 18 per hour. Without changing any of the underlying assumptions in your budgeting assumptions tab, calculate the following revised figures related to the 2017 budget:
a. Ending finished goods inventory at December 31. 2017.
b. The Break-Even point in unit sales.
c. Variable costing net operating income.
4. Go to the Budgeting Assumptions tab in your Microsoft Excel worksheet. Change the direct labor cost per hour from $18 to $19. Do your answers to 3a through 3c match the numbers that appear in your Excel worksheet? If not, why?
Want to see the full answer?
Check out a sample textbook solutionChapter IE Solutions
BREWER ND LL INTRO MGRL ACTG CON+ AC
- Sales Revenue Approach, Variable Cost Ratio, Contribution Margin Ratio Arberg Companys controller prepared the following budgeted income statement for the coming year: Required: 1. What is Arbergs variable cost ratio? What is its contribution margin ratio? 2. Suppose Arbergs actual revenues are 30,000 more than budgeted. By how much will operating income increase? Give the answer without preparing a new income statement 3. How much sales revenue must Arberg earn to break even? Prepare a contribution margin income statement to verify the accuracy of your answer. 4. What is Arbergs expected margin of safety? 5. What is Arbergs margin of safety if sales revenue is 380,000?arrow_forwardCustomers as a Cost Object Morrisom National Bank has requested an analysis of checking account profitability by customer type. Customers are categorized according to the size of their account: low balances, medium balances, and high balances. The activities associated with the three different customer categories and their associated annual costs are as follows: Additional data concerning the usage of the activities by the various customers are also provided: Required: (Note: Round answers to two decimal places.) 1. Calculate a cost per account per year by dividing the total cost of processing and maintaining checking accounts by the total number of accounts. What is the average fee per month that the bank should charge to cover the costs incurred because of checking accounts? 2. Calculate a cost per account by customer category by using activity rates. 3. Currently, the bank offers free checking to all of its customers. The interest revenues average 90 per account; however, the interest revenues earned per account by category are 80, 100, and 165 for the low-, medium-, and high-balance accounts, respectively. Calculate the average profit per account (average revenue minus average cost from Requirement 1). Then calculate the profit per account by using the revenue per customer type and the unit cost per customer type calculated in Requirement 2. 4. CONCEPTUAL CONNECTION After the analysis in Requirement 3, a vice president recommended eliminating the free checking feature for low-balance customers. The bank president expressed reluctance to do so, arguing that the low-balance customers more than made up for the loss through cross-sales. He presented a survey that showed that 50% of the customers would switch banks if a checking fee were imposed. Explain how you could verify the presidents argument by using ABC.arrow_forwardFriendly Bank is attempting to determine the cost behavior of its small business lending operations. One of the major activities is the application activity. Two possible activity drivers have been mentioned: application hours (number of hours to complete the application) and number of applications. The bank controller has accumulated the following data for the setup activity: Required: 1. Estimate a regression equation with application hours as the activity driver and the only independent variable. If the bank forecasts 2,600 application hours for the next month, what will be the budgeted application cost? 2. Estimate a regression equation with number of applications as the activity driver and the only independent variable. If the bank forecasts 80 applications for the next month, what will be the budgeted application cost? 3. Which of the two regression equations do you think does a better job of predicting application costs? Explain. 4. Run a multiple regression to determine the cost equation using both activity drivers. What are the budgeted application costs for 2,600 application hours and 80 applications?arrow_forward
- Classify each of the following actions as either being associated with the financial accounting information system (FS) or the cost management information system (CMS): a. Determining the total compensation of the CEO of a public company b. Issuing a quarterly earnings report c. Determining the unit product cost using TDABC d. Calculating the number of units that must be sold to break even e. Preparing a required report for the SEC f. Preparing a sales budget g. Using cost and revenue information to decide whether to keep, or drop, a product line h. Preparing an annual statement of financial position that conforms to generally accepted accounting principles (GAAP) i. Using cost and revenue information to decide whether to invest in a new production system or not j. Reducing costs by improving the overall quality of a product k. Using a debt-equity ratio and liquidity ratios from a balance sheet to assess the likelihood of bankruptcy l. Using a public companys financial statements to decide whether or not to buy its stockarrow_forwardRefer to Cornerstone Exercise 3.4 for data on Dohini Manufacturing Companys purchasing cost and number of purchase orders. The controller for Dohini Manufacturing ran regression on the data, and the coefficients shown by the regression program are: Required: 1. Construct the cost formula for the purchasing activity showing the fixed cost and the variable rate. 2. If Dohini Manufacturing Company estimates that next month will have 430 purchase orders, what is the total estimated purchasing cost for that month? (Round your answer to the nearest dollar.) 3. What if Dohini Manufacturing wants to estimate purchasing cost for the coming year and expects 5,340 purchase orders? What will estimated total purchasing cost be? (Round your answer to the nearest dollar.) What is the total fixed purchasing cost? Why doesnt it equal the fixed cost calculated in Requirement 1?arrow_forwardOn the production budget, the number of units to be produced is computed as Select one: a. unit sales + desired end inventory + beginning inventory. b. unit sales - desired end inventory - beginning inventory. c. unit sales - desired end inventory + beginning inventory. d. unit sales + desired end inventory - beginning inventory. e. unit sales - cost of goods sold + beginning inventory. PreviousSave AnswersNextarrow_forward
- Required: a) Using Activity Based Costing, calculate the rate for each cost driver. b) Using activity based budgeting, prepare a budgeted yearly operating statement for Aero3D Ltd. Show the following separately, within the statement. i. The budgeted output for each product per year; ii. The contribution to profits for each product and in total before charging activity based costs; iii. The profit for each product and in total after charging activity based costs but before charging core costs (non-activity based costs); iv. The total profit after charging core based costs.arrow_forwardCalculating cost-volume-profit elements The budgets of four companies yield the following information: Requirements Fill in me blanks for each missing value. (Round the contribution margin per unit to the nearest cent.) Which company has the lowest breakeven point in sales dollars? What causes the low breakeven point?arrow_forward1. Prepare a Sales Budget 2. Determine a production volume. 3. Estimate manufacturing cost and operating expense. a. Purchase (material budget) b. Personnel budget c. Overhead budget d. Selling and Administrative budget 4. Determine cash flow and other financial effects. a. Cash collection schedule b. Cash disbursement for purchases, factory overhead, and selling and administrative expense. c. Cash budget 5. Formulate Projected Financial Statement (As of December 31, 3021) a. Budgeted cost of goods manufactured b. Budgeted income statement c. Budgeted Balance Sheetarrow_forward
- 1) The sales budget is based on assumptions about the ___________. a) Number of units to be sold and selling price per unit. b) Timing of cash receipts. c) Contribution margin per unit and the number of units to be sold. d) Costs of the units produced and the total fixed costs. 2) When constructing the production budget, the desired ending inventory for the period is determined based on: a) Next period sales b) Next period production c) Last period production and sales d) Credit period 3)Standard time allowed to complete one unit is 2 hours. A worker during a week (48 hours) completed 20 units and drawn a salary of Rs. 6000. The standard rate per day of 8 hours shift is Rs. 1000. Which one of the following is true? a)Labour efficiency variance is Zero b)Labour rate variance is zero c)Labour cost variance is zero d)None of the abovearrow_forwardWhich of the following budgets will show the expected cash receipts and expected cash disbursements of the firm? * budgeted balance sheet cost of goods sold budget budgeted income statement O cash budget Working capital is the total current assets and current liabilities * True False It is the cost of ordering raw materials. Your answerarrow_forwardHow many statements below regarding margin of safety are correct? 1. It is the amount by which sales can be reduced without incurring a loss. 2. It is the difference between budgeted sales and breakeven sales. 3. It can be expressed in terms of unit, pesos or percentage of sales. 4. Its presence indicates that the company expects profit. 5. The product of margin of safety units and unit contribution margin is the projected profit for the period. 6. The higher the margin of safety, the lower is the risk of incurring operating loss. 3 4arrow_forward
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning