Potted Plants, a manufacturer of indoor gardening equipment, has presented the following budgetary and actual information about their latest product innovation, the Total Home Control system. It's a complete package that allows aspiring gardeners in northern climates to grow small vegetable gardens in basements on a year round basis. Planning Budget Actual Results Quantity 1,962 1,939 Sales $184,880 $178,031 Materials - Variable 23,167 23,960 Labor - Variable 31,237 35,536 Labor - Fixed 28,363 27,089 Overhead - Variable 19,780 19,864 Overhead - Fixed 9.631 10,289 Delivery - Variable 9,205 9,419 Rent - Fixed 2,276 2,276 Depreciation - Fixed $6,312 $6.312 What is the projected net income from the flexible budget for the period? Your answer should be to the nearest whole dollar.

Potted Plants, a manufacturer of indoor gardening equipment, has presented the following budgetary and actual information about their latest product innovation, the Total Home Control system. It's a complete package that allows aspiring gardeners in northern climates to grow small vegetable gardens in basements on a year round basis. Planning Budget Actual Results Quantity 1,962 1,939 Sales $184,880 $178,031 Materials - Variable 23,167 23,960 Labor - Variable 31,237 35,536 Labor - Fixed 28,363 27,089 Overhead - Variable 19,780 19,864 Overhead - Fixed 9.631 10,289 Delivery - Variable 9,205 9,419 Rent - Fixed 2,276 2,276 Depreciation - Fixed $6,312 $6.312 What is the projected net income from the flexible budget for the period? Your answer should be to the nearest whole dollar.

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter4: Activity-based Costing

Section: Chapter Questions

Problem 9E: Nozama.com Inc. sells consumer electronics over the Internet. For the next period, the budgeted cost...

See similar textbooks

Similar questions

Resource Usage Model, Special Order Ehrling, Inc., manufactures metal racks for hanging clothing in retail stores. Ehrling was approached by the CEO of Carly’s Corner, a regional nonprofit food bank, with an offer to buy 350 heavy-duty metal racks for storing canned goods and dry food products. While racks normally sell for $245 each, Carly’s Corner offered $75 per rack. The CEO explained that the number of families they served had grown significantly over the past two years, and that the charity needed additional storage for the donated food items. Since Ehrling is operating at 80 percent of capacity, and Ehrling employees have “adopted” Carly’s Corner as their annual charity, the company wants to make the special order work. Ehrling’s controller looked into the cost of the storage racks using the following information from the activity-based accounting system: Activity Rate** Activity Driver UnusedCapacity QuantityDemanded* Fixed Variable Direct materials Number of racks 0…
EcoSacks manufactures cloth shopping bags. The controller is preparing a budget for the coming year and asks for your assistance. The following costs and other data apply to bag production. Direct materials per bag 1.0 yard cotton at $4 per yard 0.2 yards canvas finish at $12 per yard Direct labor per bag 0.5 hour at $18 per hour Overhead per bag Indirect labor $ 0.60 Indirect materials 0.20 Power 0.40 Equipment costs 1.30 Building occupancy 0.90 Total overhead per unit $ 3.40 You learn that equipment costs and building occupancy are fixed and are based on a normal production of 600,000 units per year. Other overhead costs are variable. Plant capacity is sufficient to produce 750,000 units per year. Labor costs per hour are not expected to change during the year. However, the cotton supplier has informed EcoSacks that it will impose a 20 percent price increase at the start of the coming budget period. No…
Eliot Sprinkler Systems produces equipment for lawn irrigation. One of the parts used in selected Eliot equipment is a specialty nozzle. The budgeting team is now determining the purchase requirements and monthly cash disbursements for this part. Eliot wishes to have in stock enough nozzles to use for the coming month. On August 1, the company has 18,700 nozzles in stock, although the latest estimate for August production indicates a requirement for only 18,800 nozzles. Total uses of the nozzle are expected to be 18,500 in September and 19,340 in October. Nozzles are purchased at a wholesale price of $27. Eliot pays 25 percent of the purchase price in cash in the month when the parts are delivered. The remaining 75 percent is paid in the following month. Eliot purchased 40,000 parts in July. Required: Estimate purchases of the nozzle (in units) for August and September. Estimate the cash disbursements for nozzles in August and September.
Roboclean Ltd makes two types of robotic vacuum cleaner: iClean and HiClean. Both products offer a high level of cleaning suction, but the HiClean includes the benefit of an anti-allergy filter when the air is expelled. Spring is the busiest time of year and the management accountant has provided the following budgeted information for the month of January 2019: Fixed costs for the month are estimated at £40,000. These are divided equally between the two products. The selling price of iClean is £32.50. The direct costs of each iClean are direct materials £12.00 and direct labour £3.00. The selling price of HiClean is £40.00. The direct costs of each HiClean are direct materials £14.00 and direct labour £2.00. You have been asked to provide a report that will help the managing director consider the effect of changes in the level of sales activity and other factors on the company’s financial objectives for the month. Required Prepare a marginal cost statement for January…
MULTI COLORED PICTURE ATTACHED IS THE PART I NEED HELP WITH SECOND IS PART OF THE INFORMATION GIVEN WITH THE QUESTION The Grady Tire Company manufactures racing tires for bicycles. Grady sells tires for $70 each. Grady is planning for the next year by developing a master budget by quarters. Grady's balance sheet for Decembe 31,2018, follows: a. Budgeted sales are 1,800 tires for the first quarter and expected to increase by 50 tires per quarter. Cash sales are expected to be 20% of total sales, with the remaining 80% of sales on account. b. Finished Goods Inventory on December 31, 2018 consists of 100 tires at $36 each. c. Desired ending Finished Goods Inventory is 50% of the next quarter's sales; first quarter sales for 2020 are expected be 2,000 tires. FIFO inventory costing method is used. d. Raw Materials Inventory on December 31, 2018, consists of 200 pounds of rubber compound used to manufacture the tires. e. Direct materials requirements are 2 pounds of a rubber compound…
Scholastic Furniture, Inc., manufactures a variety of desks, chairs, tables, and shelf units that are sold to public school systems throughout the Midwest. The controller of the company’s Desk Division is currently preparing a budget for the second quarter of the year. The following sales forecast has been made by the division’s sales manager. April 10,000 desk-and-chair sets May 12,000 desk-and-chair sets June 15,000 desk-and-chair sets Each desk-and-chair set requires 10 board feet of pine planks and 1.5 hours of direct labor. Each set sells for $50. Pine planks cost $0.50 per board foot, and the division ends each month with enough wood to cover 10 percent of the next month’s production requirements. The division incurs a cost of $20 per hour for direct-labor wages and fringe benefits. The division ends each month with enough finished-goods inventory to cover 20 percent of the next month’s sales.Required:Complete the following budget schedules.1. Sales budget.2.…
GreenLawns provides a lawn fertilizing and weed control service. The company is adding a special aeration treatment as a low-cost extra service option that it hopes will help attract new customers. Management is planning to promote this new service in two media: radio and direct-mail advertising. A media budget of 3,000 is available for this promotional campaign. Based on past experience in promoting its other services, GreenLawns has obtained the following estimate of the relationship between sales and the amount spent on promotion in these two media: S=2R210M28RM+18R+34M, where S = total sales in thousands of dollars R = thousands of dollars spent on radio advertising M = thousands of dollars spent on direct-mail advertising GreenLawns would like to develop a promotional strategy that will lead to maximum sales subject to the restriction provided by the media budget. a. What is the value of sales if 2,000 is spent on radio advertising and 1,000 is spent on direct-mail advertising? b. Formulate an optimization problem that can be solved to maximize sales subject to the media budget of spending no more than 3,000 on total advertising. c. Determine the optimal amount to spend on radio and direct-mail advertising. How much in sales will be generated?
Novo, Inc., wants to develop an activity flexible budget for the activity of moving materials. Novo uses eight forklifts to move materials from receiving to stores. The forklifts are also used to move materials from stores to the production area. The forklifts are obtained through an operating lease that costs 18,000 per year per forklift. Novo employs 25 forklift operators who receive an average salary of 50,000 per year, including benefits. Each move requires the use of a crate. The crates are used to store the parts and are emptied only when used in production. Crates are disposed of after one cycle (two moves), where a cycle is defined as a move from receiving to stores to production. Each crate costs 1.80. Fuel for a forklift costs 3.60 per gallon. A gallon of gas is used every 20 moves. Forklifts can make three moves per hour and are available for 280 days per year, 24 hours per day (the remaining time is downtime for various reasons). Each operator works 40 hours per week and 50 weeks per year. Required: 1. Prepare a flexible budget for the activity of moving materials, using the number of cycles as the activity driver. 2. Calculate the activity capacity for moving materials. Suppose Novo works at 80 percent of activity capacity and incurs the following costs: Prepare the budget for the 80 percent level and then prepare a performance report for the moving materials activity. 3. Calculate and interpret the volume variance for moving materials. 4. Suppose that a redesign of the plant layout reduces the demand for moving materials to one-third of the original capacity. What would be the budget formula for this new activity level? What is the budgeted cost for this new activity level? Has activity performance improved? How does this activity performance evaluation differ from that described in Requirement 2? Explain.
Optima Company is a high-technology organization that produces a mass-storage system. The design of Optimas system is unique and represents a breakthrough in the industry. The units Optima produces combine positive features of both compact and hard disks. The company is completing its fifth year of operations and is preparing to build its master budget for the coming year (20X1). The budget will detail each quarters activity and the activity for the year in total. The master budget will be based on the following information: a. Fourth-quarter sales for 20X0 are 55,000 units. b. Unit sales by quarter (for 20X1) are projected as follows: The selling price is 400 per unit. All sales are credit sales. Optima collects 85% of all sales within the quarter in which they are realized; the other 15% is collected in the following quarter. There are no bad debts. c. There is no beginning inventory of finished goods. Optima is planning the following ending finished goods inventories for each quarter: d. Each mass-storage unit uses 5 hours of direct labor and three units of direct materials. Laborers are paid 10 per hour, and one unit of direct materials costs 80. e. There are 65,700 units of direct materials in beginning inventory as of January 1, 20X1. At the end of each quarter, Optima plans to have 30% of the direct materials needed for next quarters unit sales. Optima will end the year with the same amount of direct materials found in this years beginning inventory. f. Optima buys direct materials on account. Half of the purchases are paid for in the quarter of acquisition, and the remaining half are paid for in the following quarter. Wages and salaries are paid on the 15th and 30th of each month. g. Fixed overhead totals 1 million each quarter. Of this total, 350,000 represents depreciation. All other fixed expenses are paid for in cash in the quarter incurred. The fixed overhead rate is computed by dividing the years total fixed overhead by the years budgeted production in units. h. Variable overhead is budgeted at 6 per direct labor hour. All variable overhead expenses are paid for in the quarter incurred. i. Fixed selling and administrative expenses total 250,000 per quarter, including 50,000 depreciation. j. Variable selling and administrative expenses are budgeted at 10 per unit sold. All selling and administrative expenses are paid for in the quarter incurred. k. The balance sheet as of December 31, 20X0, is as follows: l. Optima will pay quarterly dividends of 300,000. At the end of the fourth quarter, 2 million of equipment will be purchased. Required: Prepare a master budget for Optima Company for each quarter of 20X1 and for the year in total. The following component budgets must be included: 1. Sales budget 2. Production budget 3. Direct materials purchases budget 4. Direct labor budget 5. Overhead budget 6. Selling and administrative expenses budget 7. Ending finished goods inventory budget 8. Cost of goods sold budget (Note: Assume that there is no change in work-in-process inventories.) 9. Cash budget 10. Pro forma income statement (using absorption costing) (Note: Ignore income taxes.) 11. Pro forma balance sheet (Note: Ignore income taxes.)
Biotechtron, Inc., has two research laboratories in the Southwest, one in Yuma, Arizona, and the other in Bernalillo, New Mexico. The owner of Biotechtron centralized the legal services function in the Yuma office and had both laboratories send any legal questions or issues to the Yuma office. The legal services support center has budgeted fixed costs of 160,000 per year and a budgeted variable rate of 65 per hour of professional time. The normal usage of the legal services center is 2,600 hours per year for the Yuma office and 1,400 hours per year for the Bernalillo office. This corresponds to the expected usage for the coming year. Required: 1. Determine the amount of legal services support center costs that should be assigned to each office. 2. Since the offices produce services, not tangible products, what purpose is served by allocating the budgeted costs? 3. Now, assume that during the year, the legal services center incurred actual fixed costs of 163,000 and actual variable costs of 272,400. It delivered 4,180 hours of professional time2,580 hours to Yuma and 1,600 hours to Bernalillo. Determine the amount of the legal services centers costs that should be allocated to each office. Explain the purposes of this allocation. 4. Did the costs allocated differ from the costs incurred by the legal services center? If so, why?
Friendly 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?
Nozama.com Inc. sells consumer electronics over the Internet. For the next period, the budgeted cost of the sales order processing activity is 250,000 and 50,000 sales orders are estimated to be processed. a. Determine the activity rate of the sales order processing activity. b. Determine the amount of sales order processing cost associated with 30,000 sales orders.