Question: Merline Manufacturing makes its product for $75
Merline Manufacturing makes its product for $75 per unit and sells it for $150 per unit. The sales staff receives a 10% commission on the sale of each unit. Its December income statement follows.
Management expects December’s results to be repeated in January, February, and March of 2016 without any changes in strategy. Management, however, has an alternative plan. It believes that unit sales will increase at a rate of 10% each month for the next three months (beginning with January) if the item’s selling price is reduced to $125 per unit and advertising expenses are increased by 15% and remain at that level for all three months. The cost of its product will remain at $75 per unit, the sales staff will continue to earn a 10% commission, and the remaining expenses will stay the same.
Required
1. Prepare budgeted income statements for each of the months of January, February, and March that show the expected results from implementing the proposed changes. Use a three-column format, with one column for each month.
Analysis Component
2. Use the budgeted income statements from part 1 to recommend whether management should implement the proposed changes. Explain.
Transcribed Image Text:
MERLINE MANUFACTURING Income Statement For Month Ended December 31, 2015 Sales ..... $2,250,000 Cost of goods sold 1,125,000 Gross profit .... Operating expenses Sales commissions (10%) 1,125,000 225,000 Advertising 250,000 Store rent 30,000 Administrative salaries 45,000 Depreciation-Office equipment Other expenses Total expenses 50,000 10,000 610,000 Net income $ 515,000
> Santana Rey is considering the purchase of equipment for Business Solutions that would allow the company to add a new product to its computer furniture line. The equipment is expected to cost $300,000 and to have a six-year life and no salvage value. It
> Santana Rey’s two departments, computer consulting services and computer workstation furniture manufacturing, have each been profitable. Santana has heard of the balanced scorecard and wants you to provide details on how it could be used to measure perfo
> Santana Rey expects second-quarter 2016 sales of her new line of computer furniture to be the same as the first quarter’s sales (reported below) without any changes in strategy. Monthly sales averaged 40 desk units (sales price of $1,25
> After reading an article about activity-based costing in a trade journal for the furniture industry, Santana Rey wondered if it was time to critically analyze overhead costs at Business Solutions. In a recent month, Rey found that setup costs, inspection
> The following is taken from Mortan Co.’s internal records of its factory with two operating departments. The cost driver for indirect labor and supplies is direct labor costs, and the cost driver for the remaining overhead items is numb
> A company has two products: standard and deluxe. The company expects to produce 34,300 standard units and 69,550 deluxe units. It uses activity-based costing and has prepared the following analysis showing budgeted cost and cost driver activity for each
> Refer to the information in QS C-2. Compute the overhead activity rate for each activity, assuming the company uses activity-based costing. Information from QS C-2: Chan Company identified the following activities, costs, and activity drivers for 2015.
> Esme Company’s management is trying to decide whether to eliminate Department Z, which has produced low profits or losses for several years. The company’s 2015 departmental income statements show the following. In an
> Sung Company is able to produce two products, R and T, with the same machine in its factory. The following information is available. The company presently operates the machine for a single eight-hour shift for 22 working days each month. Management is
> Windmire Company manufactures and sells to local wholesalers approximately 300,000 units per month at a sales price of $4 per unit. Monthly costs for the production and sale of this quantity follow. A new out-of-state distributor has offered to buy 50,0
> Grossman Corporation is considering a new project requiring a $30,000 investment in an asset having no salvage value. The project would produce $12,000 of pretax income before depreciation at the end of each of the next six years. The companyâ€
> Aikman Company has an opportunity to invest in one of two projects. Project A requires a $240,000 investment for new machinery with a four-year life and no salvage value. Project B also requires a $240,000 investment for new machinery with a three-year l
> Cortino Company is planning to add a new product to its line. To manufacture this product, the company needs to buy a new machine at a $300,000 cost with an expected four-year life and a $20,000 salvage value. All sales are for cash and all costs are out
> Rita and Rick Redding own and operate a tomato grove. After preparing the following income statement, Rita believes they should have offered the No. 3 tomatoes to the public for free and saved themselves time and money. In preparing this statement, Rit
> Sadar Company operates a store with two departments: videos and music. Information about those departments follows. The company also incurred the following indirect costs. Indirect costs are allocated as follows: advertising on the basis of sales; sa
> Bonanza Entertainment began operations in January 2015 with two operating (selling) departments and one service (office) department. Its departmental income statements follow. The company plans to open a third department in January 2016 that will sell
> Harmon’s has several departments that occupy all floors of a two-story building that includes a basement floor. Harmon rented this building under a long-term lease negotiated when rental rates were low. The departmental accounting syste
> Britney Brown, the plant manager of LMN Co.’s Chicago plant, is responsible for all of that plant’s costs other than her own salary. The plant has two operating departments and one service department. The refrigerator
> Kenya Company’s standard cost accounting system recorded this information from its June operations. Required 1. Prepare journal entries dated June 30 to record the company’s costs and variances for the month. (Do not
> Refer to information in Problem 23-4B. Required Compute these variances: (a) variable overhead spending and efficiency, (b) fixed overhead spending and volume, and (c) total overhead controllable. Information from Problem 23-4B: Kryll Company set the f
> Kryll Company set the following standard unit costs for its single product. The predetermined overhead rate is based on a planned operating volume of 80% of the productive capacity of 60,000 units per quarter. The following flexible budget information
> Suncoast Company set the following standard costs for one unit of its product. The predetermined overhead rate ($16.00 per direct labor hour) is based on an expected volume of 75% of the factory’s capacity of 20,000 units per month. F
> Refer to the information in Problem 23-1B. Tohono Company’s actual income statement for 2015 follows. Required 1. Prepare a flexible budget performance report for 2015. Analysis Component 2. Analyze and interpret both the (a) sales v
> Tohono Company’s 2015 master budget included the following fixed budget report. It is based on an expected production and sales volume of 20,000 units. Required 1. Classify all items listed in the fixed budget as variable or fixed. Al
> Near the end of 2015, the management of Isle Corp., a merchandising company, prepared the following estimated balance sheet for December 31, 2015. To prepare a master budget for January, February, and March of 2016, management gathers the following inf
> Connick Company sells its product for $22 per unit. Its actual and budgeted sales follow. All sales are on credit. Recent experience shows that 40% of credit sales is collected in the month of the sale, 35% in the month after the sale, 23% in the secon
> During the last week of March, Sony Stereo’s owner approaches the bank for an $80,000 loan to be made on April 1 and repaid on June 30 with annual interest of 12%, for an interest cost of $2,400. The owner plans to increase the store&ac
> H20 Sports Company is a merchandiser of three different products. The company’s March 31 inventories are water skis, 40,000 units; tow ropes, 90,000 units; and life jackets, 150,000 units. Management believes that excessive inventories
> The management of Nabar Manufacturing prepared the following estimated balance sheet for June, 2015: To prepare a master budget for July, August, and September of 2015, management gathers the following information: a. Sales were 20,000 units in June. F
> HCS Mfg. makes its product for $60 and sells it for $130 per unit. The sales staff receives a 10% commission on the sale of each unit. Its June income statement follows. Management expects June’s results to be repeated in July, August
> A1 Manufacturing is preparing its master budget for the quarter ended September 30, 2015. Budgeted sales and cash payments for product costs for the quarter follow. Sales are 20% cash and 80% on credit. All credit sales are collected in the month follo
> NSA Company produces baseball bats. Each bat requires 3 pounds of aluminum alloy. Management predicts that 8,000 bats and 15,000 pounds of aluminum alloy will be in inventory on March 31 of the current year and that 250,000 bats will be sold during this
> Elegant Decor Company’s management is trying to decide whether to eliminate Department 200, which has produced losses or low profits for several years. The company’s 2015 departmental income statements show the followi
> Edgerron Company is able to produce two products, G and B, with the same machine in its factory. The following information is available. The company presently operates the machine for a single eight-hour shift for 22 working days each month. Management
> Jones Products manufactures and sells to wholesalers approximately 400,000 packages per year of underwater markers at $6 per package. Annual costs for the production and sale of this quantity are shown in the table. A new wholesaler has offered to buy
> Manning Corporation is considering a new project requiring a $90,000 investment in test equipment with no salvage value. The project would produce $66,000 of pretax income before depreciation at the end of each of the next six years. The companyâ&#
> Most Company has an opportunity to invest in one of two new projects. Project Y requires a $350,000 investment for new machinery with a four-year life and no salvage value. Project Z requires a $350,000 investment for new machinery with a three-year life
> Factor Company is planning to add a new product to its line. To manufacture this product, the company needs to buy a new machine at a $480,000 cost with an expected four-year life and a $20,000 salvage value. All sales are for cash, and all costs are out
> Georgia Orchards produced a good crop of peaches this year. After preparing the following income statement, the company believes it should have given its No. 3 peaches to charity and saved its efforts. In preparing this statement, the company allocated
> Vortex Company operates a retail store with two departments. Information about those departments follows. The company also incurred the following indirect costs. Indirect costs are allocated as follows: salaries on the basis of sales; insurance and d
> Williams Company began operations in January 2015 with two operating (selling) departments and one service (office) department. Its departmental income statements follow. Williams plans to open a third department in January 2016 that will sell painting
> National Bank has several departments that occupy both floors of a two-story building. The departmental accounting system has a single account, Building Occupancy Cost, in its ledger. The types and amounts of occupancy costs recorded in this account for
> Billie Whitehorse, the plant manager of Travel Free’s Indiana plant, is responsible for all of that plant’s costs other than her own salary. The plant has two operating departments and one service department. The campe
> Boss Company’s standard cost accounting system recorded this information from its December operations. Required 1. Prepare December 31 journal entries to record the company’s costs and variances for the month. (Do no
> Refer to information in Problem 23-4A. Required Compute these variances: (a) variable overhead spending and efficiency, (b) fixed overhead spending and volume, and (c) total overhead controllable. Information from Problem 23-4A: Trico Company set the f
> Trico Company set the following standard unit costs for its single product. The predetermined overhead rate is based on a planned operating volume of 80% of the productive capacity of 60,000 units per quarter. The following flexible budget information
> Antuan Company set the following standard costs for one unit of its product. The predetermined overhead rate ($18.50 per direct labor hour) is based on an expected volume of 75% of the factory’s capacity of 20,000 units per month. Fol
> Refer to the information in Problem 23-1A. Phoenix Company’s actual income statement for 2015 follows. Required 1. Prepare a flexible budget performance report for 2015. Analysis Component 2. Analyze and interpret both the (a) sales
> Phoenix Company’s 2015 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. Required 1. Classify all items listed in the fixed budget as variable or fixed. A
> Built-Tight is preparing its master budget for the quarter ended September 30, 2015. Budgeted sales and cash payments for product costs for the quarter follow: Sales are 20% cash and 80% on credit. All credit sales are collected in the month following
> Near the end of 2015, the management of Dimsdale Sports Co., a merchandising company, prepared the following estimated balance sheet for December 31, 2015. To prepare a master budget for January, February, and March of 2016, management gathers the foll
> Aztec Company sells its product for $180 per unit. Its actual and budgeted sales follow. All sales are on credit. Recent experience shows that 20% of credit sales is collected in the month of the sale, 50% in the month after the sale, 28% in the second
> During the last week of August, Oneida Company’s owner approaches the bank for a $100,000 loan to be made on September 2 and repaid on November 30 with annual interest of 12%, for an interest cost of $3,000. The owner plans to increase
> Keggler’s Supply is a merchandiser of three different products. The company’s February 28 inventories are footwear, 20,000 units; sports equipment, 80,000 units; and apparel, 50,000 units. Management believes that exce
> The management of Zigby Manufacturing prepared the following estimated balance sheet for March, 2015: To prepare a master budget for April, May, and June of 2015, management gathers the following information: a. Sales for March total 20,500 units. Fore
> Maxlon Company manufactures custom-made furniture for its local market and produces a line of home furnishings sold in retail stores across the country. The company uses traditional volume-based methods of assigning direct materials and direct labor to i
> Tent Master produces two lines of tents sold to outdoor enthusiasts. The tents are cut to specifications in department A. In department B the tents are sewn and folded. The activities, costs, and drivers associated with these two manufacturing processes
> Craftmore Machining produces machine tools for the construction industry. The following details about overhead costs were taken from its company records. Additional information on the drivers for its production activities follows. Required 1. Compute
> B2B Co. is considering the purchase of equipment that would allow the company to add a new product to its line. The equipment is expected to cost $360,000 with a six-year life and no salvage value. It will be depreciated on a straight-line basis. The com
> Refer to the information in Exercise 25-5. Assume the company requires a 10% rate of return on its investments. Compute the net present value of each potential investment. (Round to the nearest dollar.) Information from Exercise 25-5: a. A new operating
> Compute the payback period for each of these two separate investments (round the payback period to two decimals): a. A new operating system for an existing machine is expected to cost $520,000 and have a useful life of six years. The system yields an inc
> Refer to the information in Exercise 25-3 and assume instead that double-declining depreciation is applied. Compute the machine’s payback period (ignore taxes). (Round the payback period to three decimals.) Information from Exercise 25
> A machine can be purchased for $150,000 and used for five years, yielding the following net incomes. In projecting net incomes, straight-line depreciation is applied, using a five-year life and a zero salvage value. Compute the machine’
> This chapter explained two methods to evaluate investments using recovery time, the payback period and break-even time (BET). Refer to QS 25-26 and (1) compute the recovery time for both the payback period and break-even time, (2) discuss the advantage(s
> Xinhong Company is considering replacing one of its manufacturing machines. The machine has a book value of $45,000 and a remaining useful life of 5 years, at which time its salvage value will be zero. It has a current market value of $52,000. Variable m
> Suresh Co. expects its five departments to yield the following income for next year. Recompute and prepare the departmental income statements (including a combined total column) for the company under each of the following separate scenarios: Management
> Colt Company owns a machine that can produce two specialized products. Production time for Product TLX is two units per hour and for Product MTV is five units per hour. The machine’s capacity is 2,750 hours per year. Both products are s
> Cobe Company has already manufactured 28,000 units of Product A at a cost of $28 per unit. The 28,000 units can be sold at this stage for $700,000. Alternatively, the units can be further processed at a $420,000 total additional cost and be converted int
> Varto Company has 7,000 units of its sole product in inventory that it produced last year at a cost of $22 each. This year’s model is superior to last year’s and the 7,000 units cannot be sold at last year’s regular selling price of $35 each. Varto has t
> A company must decide between scrapping or reworking units that do not pass inspection. The company has 22,000 defective units that cost $6 per unit to manufacture. The units can be sold as is for $2.50 each, or they can be reworked for $4.50 each and th
> Gelb Company currently manufactures 40,000 units per year of a key component for its manufacturing process. Variable costs are $1.95 per unit, fixed costs related to making this component are $65,000 per year, and allocated fixed costs are $58,500 per ye
> Refer to the information in Exercise 25-1 and assume that Beyer requires a 10% return on its investments. Compute the net present value of this investment. (Round to the nearest dollar.) Should Beyer accept the investment? Information from Exercise 25-1
> Gilberto Company currently manufactures 65,000 units per year of one of its crucial parts. Variable costs are $1.95 per unit, fixed costs related to making this part are $75,000 per year, and allocated fixed costs are $62,000 per year. Allocated fixed co
> Goshford Company produces a single product and has capacity to produce 100,000 units per month. Costs to produce its current sales of 80,000 units follow. The regular selling price of the product is $100 per unit. Management is approached by a new custom
> Farrow Co. expects to sell 150,000 units of its product in the next period with the following results. The company has an opportunity to sell 15,000 additional units at $12 per unit. The additional sales would not affect its current expected sales. Dir
> Refer to the information in Exercise 25-10. Create an Excel spreadsheet to compute the internal rate of return for each of the projects. Round the percentage return to two decimals. Information from Exercise 25-10: Following is information on two altern
> Phoenix Company can invest in each of three cheese-making projects: C1, C2, and C3. Each project requires an initial investment of $228,000 and would yield the following annual cash flows. (1) Assuming that the company requires a 12% return from its in
> Refer to the information in Exercise 25-11. Create an Excel spreadsheet to compute the internal rate of return for each of the projects. Based on internal rate of return, determine whether the company should accept either of the two projects. Informatio
> Refer to the information in Exercise 25-11 and instead assume the company requires a 12% return on its investments. Compute each project’s (a) net present value and (b) profitability index. (Round present value calculations to the neare
> Following is information on two alternative investments being considered by Tiger Co. The company requires a 4% return from its investments. Compute each project’s (a) net present value and (b) profitability index. (Round present valu
> Following is information on two alternative investments being considered by Jolee Company. The company requires a 10% return from its investments. For each alternative project compute the (a) net present value, and (b) profitability index. (Round your
> Beyer Company is considering the purchase of an asset for $180,000. It is expected to produce the following net cash flows. The cash flows occur evenly throughout each year. Compute the payback period for this investment (round years to two decimals).
> Megamart, a retailer of consumer goods, provides the following information on two of its departments (each considered an investment center). 1. Compute return on investment for each department. Using return on investment, which department is most effic
> You must prepare a return on investment analysis for the regional manager of Fast & Great Burgers. This growing chain is trying to decide which outlet of two alternatives to open. The first location (A) requires a $1,000,000 investment and is expected to
> Jansen Company reports the following for its ski department for the year 2015. All of its costs are direct, except as noted. Prepare a (1) departmental income statement for 2015 and (2) departmental contribution to overhead report for 2015. (3) Based o
> Woh Che Co. has four departments: materials, personnel, manufacturing, and packaging. In a recent month, the four departments incurred three shared indirect expenses. The amounts of these indirect expenses and the bases used to allocate them follow. De
> Jessica Porter works in both the jewelry department and the hosiery department of a retail store. Porter assists customers in both departments and arranges and stocks merchandise in both departments. The store allocates Porter’s $30,000
> L’Oréal reports the following for a recent year for the major divisions in its cosmetics branch. 1. Compute profit margin for each division. State your answers as percents, rounded to two decimal places. Which Lâ
> Pirate Seafood Company purchases lobsters and processes them into tails and flakes. It sells the lobster tails for $21 per pound and the flakes for $14 per pound. On average, 100 pounds of lobster are processed into 52 pounds of tails and 22 pounds of fl
> Marathon Running Shop has two service departments (advertising and administrative) and two operating departments (shoes and clothing). During 2015, the departments had the following direct expenses and occupied the following amount of floor space. The
> Heart & Home Properties is developing a subdivision that includes 600 home lots. The 450 lots in the Canyon section are below a ridge and do not have views of the neighboring canyons and hills; the 150 lots in the Hilltop section offer unobstructed views
> The trailer division of Baxter Bicycles makes bike trailers that attach to bicycles and can carry children or cargo. The trailers have a retail price of $200 each. Each trailer incurs $80 of variable manufacturing costs. The trailer division has capacity
> Best Ink produces ink-jet printers for personal computers. It received an order for 500 printers from a customer. The following information is available for this order. 1. Compute the company’s manufacturing cycle time. 2. Compute the
> Oakwood Company produces maple bookcases to customer order. It received an order from a customer to produce 5,000 bookcases. The following information is available for the production of the bookcases. 1. Compute the company’s manufact
> ZNet Co. is a web-based retail company. The company reports the following for 2015. The company’s CEO believes that sales for 2016 will increase by 20%, and both profit margin (%) and the level of average invested assets will be the s
> Kraft Foods Group reports the following for two of its divisions for a recent year. All numbers are in millions of dollars. For each division, compute (1) return on investment, (2) profit margin, and (3) investment turnover for the year. Round answers t
> Refer to information in Exercise 24-9. Compute profit margin and investment turnover for each department. Which department generates the most net income per dollar of sales? Which department is most efficient at generating sales from average invested ass
> Marvin Dinardo manages an auto dealership’s service department. Costs and expenses for a recent quarter for his department follows. List the controllable costs that would appear on a responsibility accounting report for the service depa
> Refer to the information in Exercise 23-8 and compute the (1) direct materials price and (2) direct materials quantity variances. Indicate whether each variance is favorable or unfavorable. Information from Exercise 23-8: A manufactured product has the
> A manufactured product has the following information for June. Compute the (1) standard cost per unit and (2) total cost variance for June. Indicate whether the cost variance is favorable or unfavorable. Standard Actual Direct materials.. (6 Ibs. @
