Rotech Co. began operations in January 2019. The information below is for Rotech Co.'s operations for the three months from January to March (the first quarter) of 2020: Prepare a cash budget. Expenses for Quarter 1 …………………………………………… Depreciation ……………………………………………. $35,000 Factory overhead ……………………………………….. 15,000 Income taxes …………………………………………….. 25,000 Payroll ………………………………………………………... 29,000 Selling costs (2% commission on sales) ………. 12,000 Administrative costs ……………………………………. 15,000 Costs are assumed to be incurred evenly throughout the year, with the exception of depreciation and income taxes. Depreciation on new assets is first taken in the quarter after the quarter in which they are purchased. Income taxes are payable in semi-annual instalments on the first day of each six month period, based on last year's actual taxes of $30,000. Other information: 1. Sales (made evenly throughout the quarter) Quarter 1 (actual) ……………….. $600,000 Quarter 2 (forecast) ……………… 400,000 Quarter 3 (forecast) ……………… 800,000 Collections from sales are as follows: 50% in the quarter of sale; 45% in the following quarter; 5% uncollectible. 2. Purchases (made evenly throughout the quarter) Quarter 1 (actual) $300,000 The gross margin ratio is constant at 40%. Cash payments for purchases are as follows: 50% in the quarter of purchase and 50% in the following quarter. Merchandise purchased during a quarter would include 25% of the next quarter's forecast sales. 3. The company purchased capital equipment for $150,000 in February 2019. The estimated useful life of this equipment is 10 years; it has no estimated scrap value. 4. Dividends of $20,000 are declared on the last day of each quarter and are paid at the end of the next month. 5. The cash balance in the bank at the end of the first quarter is $45,000. Instructions a. Prepare a cash budget for Rotech Co. for the second quarter of 2020. Show all your supporting calculations. b. List three advantages of budgeting. Ending cash balance: $128,000
> For its three investment centres, Stahl Company accumulates the following data: Calculate the return on investment (ROI) for each centre. Calculate return on investment using ROI formula. Centre I Centre II Centre III Sales $2,000,000 $4,000,000 $
> For the year ending December 31, 2020, Sanjay Company accumulates the following data for the plastics division, which it operates as an investment centre: contribution margin—$700,000 budgeted, $715,000 actual; controllable fixed costs—$300,000 budgeted,
> Advent Manufacturing Company accumulates the following summary data for the year ending December 31, 2020, for its water division. The division operates as a profit centre: sales—$2 million budgeted, $2,080,000 actual; variable costs—$1 million budgeted,
> A company that manufactures recreational pedal boats has approached Mike Cichanowski to ask if he would be interested in using Current Designs' rotomould expertise and equipment to produce some of the pedal boat components. Mike is intrigued by the idea
> The executive team at Current Designs has gathered to evaluate the company’s operations for the last month. One of the topics on the agenda is a special order to produce a batch of 20 kayaks for a client. Mike Cichanowski asked the others if the special
> The Current Designs staff has prepared the annual manufacturing budget for the rotomoulded line based on an estimated annual production of 4,000 kayaks during 2020. Each kayak will require 54 kilograms of polyethylene powder and a finishing kit (rope, se
> In the assembly department of Osaka Company, budgeted and actual manufacturing overhead costs for the month of April 2020 were as follows: The department manager can control all costs. Prepare a responsibility report for April for the cost centre. Prep
> Data for Dukane Company are given in BE11.4. In March 2020, the company incurs the following costs in producing 100,000 units: direct materials $425,000, direct labour $590,000, and variable overhead $805,000. Actual fixed overhead equalled budgeted fixe
> Dukane Company expects to produce 1.2 million units of product XX in 2020. Monthly production is expected to range from 80,000 to 120,000 units. Budgeted variable manufacturing costs per unit are as follows: direct materials $4, direct labour $6, and ov
> In Hinsdale Company, direct labour is $20 per hour. The company expects to operate at 10,000 direct labour hours each month. In January 2020, the company incurs direct labour totalling $204,000 in working 10,400 hours. Prepare (a) a static budget report
> On July 2, 2020, the accounting staff of Waterway's B.C. plant was shocked to discover that their accounting system had been compromised by a brand new computer virus called “badget.” While their software supplier was able to provide a fix within hours o
> Data for Westphal Company are given in BE11.1. In the second quarter, budgeted sales were $400,000, and actual sales were $405,000. Prepare a static budget report for the second quarter and for the year to date. Prepare static budget reports. Data from
> Russo Manufacturing Company uses the following budgets: balance sheet, capital expenditures, cash, direct labour, direct materials, income statement, manufacturing overhead, production, sales, and selling and administrative expenses. Prepare a diagram th
> Data for the investment centres for Stahl Company are given in BE11.9. The centres expect the following changes in the next year: Centre I a 15% increase in sales; Centre II a $200,000 decrease in costs; and Centre III a $400,000 decrease in average oper
> For the quarter ended March 31, 2020, Westphal Company accumulates the following sales data for its product, Garden-Tools: $350,000 budgeted; $335,000 actual. Prepare a static budget report for the quarter. Prepare static budget reports.
> Rajiv Company has completed all of its operating budgets. The sales budget for the year shows 50,000 units and total sales of $2,250,000. The total cost of making one unit of sales is $25. It estimates selling and administrative expenses to be $300,000 a
> Rado Company classifies its selling and administrative expenses budget into variable and fixed components. It expects variable expenses to be $25,000 in the first quarter, and expects $5,000 increments in the remaining quarters of 2020. It expects fixed
> Savage Ltd. expects variable manufacturing overhead costs to be $20,000 in the first quarter of 2020, with $4,000 increments in each of the remaining three quarters. It estimates fixed overhead costs to be $35,000 in each quarter. Prepare the manufacturi
> For Tracey Company, units to be produced are 5,000 in quarter 1 and 6,000 in quarter 2. It takes 1.6 hours to make a finished unit, and the expected hourly wage rate is $15. Prepare a direct labour budget by quarters for the six months ending June 30, 20
> Gomez Company has 2,000 kg of raw materials in its December 31, 2020, ending inventory. Required production for January and February is 5,000 and 6,000 units, respectively. Two kilograms of raw materials are needed for each unit, and the estimated cost p
> Sales budget data for Maltz Company are given in BE10.2. Management wants to have an ending finished goods inventory equal to 20% of the next quarter's expected unit sales. Prepare a production budget by quarters for the first six months of 2020. Prepare
> Waterways Corporation has recently acquired a small manufacturing operation in British Columbia that produces one of its more popular items. This plant will provide these units for resale in retail hardware stores in British Columbia and Alberta. Because
> Maltz Company estimates that unit sales will be 10,000 in quarter 1; 12,000 in quarter 2; 14,000 in quarter 3; and 18,000 in quarter 4. Using a sales price of $80 per unit, prepare the sales budget by quarters for the year ending December 31, 2020. Prepa
> Journalize the following transactions for Rogler Manufacturing. a. Incurred direct labour costs of $24,000 for 3,000 hours. The standard labour cost was $25,500. b. Assigned 3,000 direct labour hours costing $24,000 to production. Standard hours were 3,1
> Journalize the following transactions for Orkin Manufacturing. a. Purchased 6,000 units of raw materials on account for $11,500. The standard cost was $12,000. b. Issued 5,600 units of raw materials for production. The standard units were 5,800. Journali
> Engles Oil Company is considering investing in a new oil well. It is expected that the oil well will increase annual revenues by $130,000 and will increase annual expenses by $70,000, including depreciation. The oil well will cost $470,000 and will have
> The Transcanadian Transportation Company uses a responsibility reporting system to measure the performance of its three investment centres: planes, taxis, and limos. It measures segment performance using a system of responsibility reports and return on i
> The Medina and Haley Dental Clinic provides both preventive and orthodontic dental services. The two owners, Martin Medina and Cybil Haley, operate the clinic as two separate investment centres: preventive services and orthodontic services. Each owner is
> The green division of Campana Company reported the following data for the current year: Calculate ROI for current year and for possible future changes. Sales …………………………………………………. $3,000,000 Variable costs ………………………………………. 1,980,000 Controllable fixed co
> The sports equipment division of Brandon McCarthy Company is operated as a profit centre. Sales for the division were budgeted for 2020 at $900,000. The only variable costs budgeted for the division were cost of goods sold ($440,000) and selling and admi
> Longhead Manufacturing Limited has three divisions that are operated as profit centres. Actual operating data for the divisions are as follows: Calculate missing amounts in responsibility reports for three profit centres, and prepare a responsibility re
> The mixing department manager of Crede Company is able to control all overhead costs except rent, property taxes, and salaries. Budgeted monthly overhead costs for the mixing department, in alphabetical order, are as follows: Prepare a responsibility rep
> Marcum Company's organization chart includes the president; the vice-president of production; three assembly plants—Vancouver, Hamilton, and Saint John; and two departments within each plant—machining and finishing. Budgeted and actual manufacturing cost
> Sherrer Company has two production departments: fabricating and assembling. At a department managers' meeting, the controller uses flexible budget graphs to explain the total budgeted costs. Separate graphs based on direct labour hours are used for each
> Viera Corporation is considering investing in a new facility. The estimated cost of the facility is $2,045,000. It will be used for 12 years, then sold for $716,000. The facility will generate annual cash inflows of $400,000 and will need new annual cash
> Tilger Farm Supply Company manufactures and sells a fertilizer called Snare. The following data are available for preparing budgets for Snare for the first two quarters of 2020. Prepare a budgeted income statement and supporting budgets. 1. Sales: Quarte
> Lorch Company prepares monthly cash budgets. Relevant data from operating budgets for 2021 are as follows: Prepare a cash budget for two months. All sales are on account. Lorch expects collections to be 50% in the month of sale, 40% in the first month
> Lyon Factory Ltd. manufactures two products: chairs and stools. Each chair requires 3 m of upholstery and 4 kg of steel. Each stool requires 2 m of upholstery and 5 kg of steel. Upholstery costs $2 per metre and steel costs $5 per kilogram. Calculate cas
> Colt Industries had sales in 2019 of $5.6 million and gross profit of $1.1 million. Management is considering two alternative budget plans to increase its gross profit in 2020. Prepare sales and production budgets and calculate the cost per unit under tw
> Colt Division had the following results for the year just ended: Compare ROI and residual income with supporting calculations. Colt is considering a new product line that would involve the following: Colt's parent company, North Inc., has a company-w
> National Motors is a major car manufacturer with a wide variety of models, including its most recent one, the Mountaineer. The new model uses parts and components from external suppliers, as well as some from the following divisions of National Motors: C
> Lawton Homes, founded by a former vice-president of Haniwall Industries in P11.45A, has been manufacturing prefabricated houses for the past five years. To compete with Haniwall, Lawton also expanded into the precut housing market by acquiring one of its
> Haniwall Industries has manufactured prefabricated houses for over 20 years. Calculate ROI and residual income and discuss impact on manager performance. The houses are constructed in sections that are assembled on customers' lots. Haniwall expanded into
> Kanjak Company uses a responsibility reporting system. It has divisions in Calgary, Winnipeg, and Sudbury. Each division has three production departments: cutting, shaping, and finishing. Responsibility for each department belongs to a manager who report
> Iqaluit Corporation recently announced a bonus plan to be awarded to the vice-president of the most profitable division. The three managers are to choose whether the ROI or residual income (RI) will be used to measure profitability. In addition, they mus
> Frost Company is evaluating the purchase of a rebuilt spotwelding machine to be used in the manufacture of a new product. The machine will cost $176,000, has an estimated useful life of seven years and a salvage value of zero, and will increase net annua
> Chudzik Manufacturing Company makes garden and lawn equipment. The company operates through three divisions. Each division is an investment centre. Operating data for the lawn mower division for the year ended December 31, 2020, and relevant budget data
> Korene Manufacturing Inc. operates the home appliance division as a profit centre. Operating data for this division for the year ended December 31, 2020, are shown in the following table: Prepare a responsibility report for a profit centre. In addition
> Laesecke Company uses budgets to control costs. The May 2020 budget report for the company's packaging department is as follows: State the total budgeted cost formula, and prepare flexible budget reports for two time periods. The monthly budget amounts
> The Big Sister Company is in a seasonal business and prepares quarterly budgets. Its fiscal year runs from January 1 through December 31. Production occurs only in the first quarter (January to March), but sales take place throughout the year. The sales
> Kurian Industries' balance sheet at December 31, 2019, follows. Prepare budgeted income statement and balance sheet. / / Budgeted data for the year 2020 include the following: To meet sales requirements and to have 3,000 units of finished goods on ha
> Kirkland Ltd. estimates sales for the second quarter of 2020 will be as follows: Prepare a raw materials purchase budget in dollars. April …………… 2,550 units May ……………. 2,475 units June ………….. 2,390 units The target ending inventory of finished products
> The budget committee of Ridder Company collects the following data for its Westwood Store in preparing budgeted income statements for July and August 2020: Prepare purchases and income statement budgets for a merchandiser. 1. The store expects sales for
> The controller of Harrington Company estimates sales and production for the first four months of 2020 as follows: Prepare a cash budget for a quarter. Sales are 40% cash and 60% on account, and 60% of credit sales are collected in the month of the sale
> Montreal Inc. manufactures garden hoses for large stores. The standard costs for a dozen garden hoses are as follows: Calculate variances. Direct materials …………â€
> Martelle Company is performing a post-audit of a project completed one year ago. The initial estimates were that the project would cost $250,000, would have a useful life of nine years and zero salvage value, and would result in net annual cash flows of
> Toronto Manufacturing Company uses a standard cost system. John Robert, a financial analyst for Toronto Manufacturing Company, has been given information with respect to standard cost variances for one of the plants. These variances are given below. Calc
> Fayman Manufacturing Company uses standard costs with its job-order cost accounting system. In January, an order (Job 84) was received for 5,500 units of product D. The standard cost of one unit of product D is as follows: Journalize and post standard co
> Pointe Claire Company applies overhead based on direct labour hours. Two direct labour hours are required for each unit of product. Planned production for the period was set at 9,000 units. Manufacturing overhead is budgeted at $135,000 for the period (2
> Hi-Tek Labs performs steroid testing services for colleges and universities. Because the company works only with educational institutions, the price of each test is strictly regulated. Therefore, the costs incurred must be carefully monitored and control
> Crede Manufacturing Company uses a standard cost accounting system. In 2020, 28,000 units were produced. Each unit took several kilograms of direct materials and 1.6 standard hours of direct labour at a standard hourly rate of $12. Normal capacity was 50
> You have been given the following information about ALG Co. Ltd., which uses a standard cost system in accounting for its one product: Calculate various amounts from standard costs and variances. 1. In the month of November 2020, 5,000 units were produce
> Kohler Clothiers manufactures women’s business suits. The company uses a standard cost accounting system. In March 2020, 15,700 suits were made. The following standard and actual cost data applied to the month of March when normal capac
> Under a contract with the provincial government, ChemLabs Ltd. analyzes the chemical and bacterial composition of well water in various municipalities in the interior of British Columbia. The contract price is $25.20 per test performed. The normal volume
> Soriano Manufacturing Company uses a standard cost accounting system to account for the manufacturing of exhaust fans. In July 2020, it accumulates the following data for 1,500 units started and finished: Calculate variances and prepare an income stateme
> Inman Corporation manufactures a single product. The standard cost per unit of product is as follows: Calculate variances. Direct materials—2 kg of plastic at $5 per kilogram ………………… $10.00 Direct labour—2 hours at $12 per hour …………………………………… 24.00 Vari
> Jonczyk Company is considering two different, mutually exclusive capital expenditure proposals. Project A will cost $395,000, has an expected useful life of 10 years and a salvage value of zero, and is expected to increase net annual cash flows by $70,00
> You have been given the following information about the production of Gamma Co., and are asked to provide the plant manager with information for a meeting with the vice-president of operations: Determine amounts from the variance report. ………………………………………
> Doggone Groomers is in the dog-grooming business. Its operating costs are described by these formulas: Prepare a flexible budget report; compare flexible and static budgets. Grooming supplies (variable) y = $0 + $4.00x Direct labour (variable) y = $0 +
> High Arctic Manufacturing Company produces one product, Kebo. Because of wide fluctuations in the demand for Kebo, the assembly department has significant variations in its monthly production levels. Prepare a flexible budget, budget report, and graph fo
> Kitchen Care Inc. (KCI) is a manufacturer of toaster ovens. To improve control over operations, the president of KCI wants to begin using a flexible budgeting system, rather than use only the current master budget. The following data are available for KC
> Alcore Company estimates that 240,000 direct labour hours will be worked in the assembly department during 2020. Based on that, the following budgeted manufacturing overhead data are calculated: Prepare a flexible budget and a budget report for manufactu
> Choo-Foo Company makes and sells artistic frames for pictures. The controller is responsible for preparing the master budget and has accumulated the following information for 2020: Prepare production and direct labour budgets. Choo-Foo has a labour con
> Greish Inc. is preparing its annual budgets for the year ending December 31, 2020. Accounting assistants have provided the following data: Prepare sales, production, direct materials, direct labour, and income statement budgets. An accounting assistant
> The budget committee of Urbina Company has collected the following data for its Eastwood Store in preparing budgeted income statements for July and August 2020. Prepare purchases and income statement budgets for a merchandiser. 1. Expected sales: July $4
> Raymond Co. began operations in January 2019. The information below is for Raymond Co.'s operations for the three months from January to March (the first quarter) of 2020: Prepare a cash budget. Expenses for Quarter 1 Depreciation …
> Nigh Company prepares monthly cash budgets. Relevant data from operating budgets for 2021 are as follows: Prepare cash budget for two months. All sales are on account. The company expects collections to be 60% in the month of sale, 30% in the first mon
> Michener Bottling Corporation is considering the purchase of a new bottling machine. The machine would cost $200,000 and has an estimated useful life of eight years with zero salvage value. Management estimates that the new bottling machine will provide
> Steelwall Inc. uses the return on investment as a performance measure and defines investment as the average operating assets. The company bases management bonuses in part on the ROI and expects all investments to earn a minimum rate of return of 18%. Cal
> Health Care Inc. (HCI) uses a flexible budgeting system, rather than only the current master budget. The following data are available for HCI's expected costs at production levels of 100,000, 110,000, and 120,000 units: Prepare a flexible budget report f
> Return on investment is often expressed as follows: Compare and contrast performances under ROI and residual income. Instructions a. Explain the advantages of breaking down the ROI calculation into two separate components. b. 1.Comparative data on three
> Kappa Company has three divisions: A, B, and C. Each year the vice-president incharge of the best-performing division is entitled to a sizeable bonus. The results for the year are now in and each vice-president has claimed that the bonus should be his or
> Northern Pride Inc., a diversified company, operates four departments. The company has collected the following departmental information for 2020: Calculate ROI and residual income and rank department performances. Instructions a. Rank the four departme
> South division had the following results for the year just ended: Compare ROI and residual income with supporting calculations. South is considering a new product line that would involve the following: South's parent company, Globe Inc., has a compan
> Alosio Manufacturing Company manufactures a variety of tools and industrial equipment. The company operates three divisions. Each division is an investment centre. Operating data for the home division for the year ended December 31, 2020, and relevant bu
> Henning Manufacturing Ltd. operates its patio furniture division as a profit centre. Operating data for this division for the year ended December 31, 2020, are as follows: Prepare a responsibility report for a profit centre. In addition, Henning Manufa
> Yaeger Company uses budgets in controlling costs. The company based the monthly budget amounts in the report on an expected production of 60,000 units per month or 720,000 units per year. The assembling department manager is pleased with the report and e
> The controller of Kari Company estimates sales and production for the first four months of 2020 as follows: Prepare a cash budget for a month. January … February … March … April Sales $40,000 … $50,000 … $60,000 … $35,000 Production in units 2,000 …
> Timo Corporation, which operates an amusement park, is considering a capital investment in a new ride. The ride would cost $136,000 and have an estimated useful life of five years. The park will sell it for $65,000 at that time. (Amusement parks need to
> Waterways puts much emphasis on cash flow when it plans for capital investments. The company chose its discount rate of 8% based on the rate of return it must pay its owners and creditors. Using that rate, Waterways then uses different methods to determi
> Raddington Inc. makes and sells chairs. The controller is responsible for preparing the master budget and has accumulated the following information for 2020: Prepare production and direct labour budgets. Raddington Inc. has a labour contract that calls
> Vergados Brothers is trying to estimate the amount of inventory it needs to purchase next month (April). The controller likes to have twice the number of units he expects to sell on hand at the beginning of the month. He always takes the 3/10, net 30 pur
> Azim Shirts Inc. manufactures sweatshirts for large stores. The standard costs for a dozen sweatshirts are: Calculate variances and prepare journal entries. Direct materials ………â€&br
> Berman Corporation uses standard costs with its job order cost accounting system. In January, an order (Job No. 12) for 1,950 units of product B was received. The standard cost of one unit of product B is as follows: Journalize and post standard cost ent
> Finley Manufacturing Corporation accumulates the following data for jobs started and finished during the month of June 2020: Calculate variances and prepare an income statement. Overhead is applied based on standard machine hours. Three hours of machin
> Service Farm Labs Inc. provides mad cow disease testing for both provincial and federal government agriculture agencies. Because the company’s customers are government agencies, prices are strictly regulated. Farm Labs must therefore constantly monitor a
> The Multi-Tool Manufacturing Company uses a standard cost system. Stéphanie Roget, a financial analyst for Multi-Tool Manufacturing Company, has been given information with respect to standard cost variances for one of the plants. These variances are giv
> Biotech Inc. applies overhead based on direct labour hours. Three direct labour hours are required for each unit of product. Planned production for the period was set at 8,100 units. Manufacturing overhead is budgeted at $405,000 for the period (30% of t
> You have been given the following information about the production of Theta Co. and are asked to provide the plant manager with information for a meeting with the vice-president of operations: Determine amounts from the variance report. â€&br
> Ronaldo Manufacturing Company uses a standard cost system in accounting for the cost of one of its products. The budgeted monthly production is 1,750 units per month. The standard direct labour cost is 15 hours per unit at $5 per hour. The budgeted cost