Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please see attached document, I only need part 2 and 10 answered. I already completed the rest but I wasn't sure about those two. If
Please see attached document, I only need part 2 and 10 answered. I already completed the rest but I wasn't sure about those two. If additional information is need for the question, please let me know. Thank You
Memories, Inc. Part One (cost driver and pre-determined overhead) Memories, Inc. (MI) produces souvenir figurines that are sold wholesale to gift shops. They have created a new line of dolls representing historical figures. The company's goal is to produce and sell 350,000 dolls each year. MI plans to keep approximately a one-month supply of dolls in finished goods inventory. MI will have 10 production lines. Each of the five workers on each line will be responsible for one of the five stages of production: molding, cleaning, painting, finishing, and packaging. Each of the 10 production lines can produce 20 dolls per hour. MI deals exclusively with Quality Materials, Inc. to purchase raw materials and equipment. All materials (plastic, molds, paint, etc.) are delivered within two days of ordering and MI generally holds only a one- or two- day supply in raw materials inventory. The projected materials costs are: Material cost per doll Plastic Doll molds Varnish Paint Packaging $.12 .20 .08 .30 .04 Direct labor employees are paid on an hourly basis according to hours worked. Once production-line workers finish a day's scheduled production, they are sent home. The can work a maximum of 8 hours each day without earning overtime. The overtime premium is an additional 50% of the base hourly rate of $7.50 per hour. Supervisors and other indirect labor employees are salaried. Labor Costs (estimated) Rate for direct labor $7.50 per hour (plus $2.50 per hour in fringe benefits) Indirect labor (per month) Supervisor (includes fringe benefits) Other (includes fringe benefits) Overhead Costs (estimated, per month) Rent on factory facility Utilities Other overhead: Indirect materials Maintenance costs Quality inspection costs Equipment (lease costs) $3,000 $2,000 $1,000 $1,475 $2,500 $1,500 $2,000 $2,500 Selling and Administrative Costs (estimated, per month) Administrative salaries $4,000 Salaries of sales staff $5,000 Product promotion and advertising $2,000 Rent on office space for staff $2,000 Utilities and insurance $ 500 Lease of office furniture and equipment $ 800 During the first year of operations, Memories, Inc. estimated that they would produce 346,125 dolls but actually produced 336,033. Actual direct materials costs were $248,664 and actual direct labor costs were $840,082 for 84,008 hours worked. Estimated overhead costs for the year were $191,700 while actual overhead was $193,000. Required: A. What is an appropriate cost driver for allocating overhead to dolls in Year 1? (Explain your reasoning for choosing the driver.) B. Calculate the predetermined overhead rate using the cost driver you identified in A. C. Using normal costing, compute the cost of one of the 336,033 dolls produced in Year 1. (Round to the nearest dollar.) D. Was overhead over- or under-applied during the year? By how much? Why do you think this happened? Part Two (COGS, COGM two products) In its second year of operations, Memories, Inc. has decided to expand the product line by producing replicas of historic buildings. These replicas will require the purchase of new building molds at a cost of $.18 per replica. Of course, new doll molds will not be required. All other materials and prices will remain the same. The replicas require additional processing time because of the details on the buildings that limits production to 18 replicas per hour per assembly line. The replicas are not expected to affect the sales of dolls. In the second year of operations, MI expects to produce and sell about 352,800 dolls and 25,200 replicas. Increasing production is expected to increase overhead costs by 5% in Year 2. Direct labor costs per hour are not expected to change, but the number of labor hours is estimated to be 94,500. The costs of product promotion and advertising are expected to increase to $3,000 per month. All other selling and administrative costs are expected to remain the same as in Year 1. Actual production in Year 2 was 345,132 dolls and 25,200 replicas. Direct material costs transferred to Work-in-Process were $259,000 for dolls and $15,624 for replicas. Direct labor costs were $862,830 for the dolls and $70,010 for replicas, representing 86,283 and 7,001 direct labor hours, respectively. Actual overhead costs were $203,600. Schedule of Beginning and Ending Inventory Amounts for Year 2 Beginning Ending Inventory Inventory Raw Materials $ 1,973 $ 3,487 Work in Process -0-0Finished Goods $ 95,000 $ 121,645 Purchases of raw materials during Year 2 were $276,138 in total. Sales during Year 2 were $1,701,410 for 340,282 dolls and $121,275 for 23,100 replicas. Required: A. Can Memories, Inc. still allocate overhead in Year 2 using the same cost driver used in Year 1? If not, what appears to be the most logical cost driver to use? (Explain your answers and support your reasoning.) B. Compute a predetermined overhead rate for MI in Year 2. C. Using normal costing and the predetermined rate from B, compute the total manufacturing cost for 345,132 dolls and 25,200 replicas produced in Year 2, as well as the cost per doll and the cost per replica. Was overhead under- or overapplied? By how much? D. Prepare a cost of goods manufactured schedule for Year 2 using actual overhead. E. Prepare a cost of goods sold schedule for Year 2 using actual overhead. F. Calculate MI's operating income (before taxes) for Year 2. G. The marketing manager estimates that Year 3 sales will be 385,000 dolls and 30,000 replicas. The production manager is concerned about being able to produce that number of figurines without incurring significant overtime or making changes in the production process. Outline the possible problems, potential objectives, and options that MI should consider. Part Three (ABC) George Jefferson, the accounting manager at MI, has just returned from a conference on activity-based costing and thinks MI should consider implementing an ABC system. George has identified five primary activities taking place in the production facilities at MI, has traced Year 2 overhead costs to each activity, and has identified a cost driver for each activity as follows: Estimated Year 2 Overhead Costs Using ABC Activity Monthly Cost Driver Overhead Cost Materials delivery and handling $4,620 Number of shipments Molding and cleaning $3,150 Number of molds Painting and finishing $5,670 Direct labor hours Packaging $1,260 Number of figurines Quality inspections $2,100 Number of inspections Based on information about production needs and the differences for each type of product (replicas are not uniform in size, dolls need more inspection, etc.) George has estimated the following activity for each cost driver: Dolls Number of shipments Direct labor hours Number of figurines Number of molds Number of inspections 52 87,500 352,800 2,500 80,000 Replicas 108 7,000 25,200 500 4,000 Total 160 94,500 378,000 3,000 84,000 Required: A. Using the preceding activities and cost drivers, calculate a predetermined overhead rate for each activity. B. Using ABC, how much estimated overhead would be allocated to a doll? to a replica? C. Compare the estimated overhead allocation using ABC to the estimated overhead allocation using direct labor hours. What do you think is the cause of the differences? D. What are some of the advantages and disadvantages of using ABC in this case? E. Would you suggest that MI adopt an ABC system? Why or why not? F. Does the information provided by the ABC system give you some insight into areas of possible cost reduction? What areas have the greatest potential for cost reduction, and what are the potential impacts on the business from these cost reductions? Part Four (High-Low Method) During the first two years of operations, Memories, Inc.'s overhead costs have fluctuated from month to month. Although overhead appears to go up and down according to the number of figurines produced each month, the accounting manager has noticed that this is not always the case. For example, in the fourteenth month of operations, the manufacturing facility was closed for almost 10 days because of severe weather and production for that month was very low. However, overhead costs were only reduced by 25% from the prior month. In an effort to estimate overhead costs for Year 3, George has collected the following information for the past 24 months of operation and has asked for your assistance in analyzing the data. Month 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Figurines Produced 25,784 25,897 25,750 26,352 27,567 28,492 27,398 28,112 29,499 28,879 29,344 29,399 30,879 15,167 28,379 29,765 30,334 30,761 31,300 31,804 31,795 32,016 32,379 32,675 Total Overhead Costs $17,200 $17,300 $17,450 $17,600 $17,950 $18,125 $17,900 $17,955 $18,507 $18,295 $18,325 $18,550 $19,825 $14,800 $18,732 $19,832 $19,965 $19,786 $20,359 $20,149 $20,508 $20,489 $21,166 $20,852 Required: A. Analyze the data, with and without month 14, using the high-low method. Estimate both the fixed costs and variable cost per unit and create the cost equation with and without month 14. Does the data from the 14th month impact the accuracy of the cost equation? B. Should the accounting manager consider using a different independent variable instead of number of figurines? What would you suggest? C. For Year 3, MI estimates January production of 33,000 figurines. Based on that expected production, how much overhead would you estimate MI will incur in January. Explain your answer. Part Five (CVP Analysis) During the third year of operations, Memories, Inc. estimates that 415,000 figurines (385,000 dolls and 30,000 replicas) will be produced. Direct material costs per unit remain at $.74 per doll and $.62 per replica. Direct labor costs are $2.51 per doll and $2.78 per replica. Monthly fixed selling and administrative costs are $15,300 while monthly fixed manufacturing overhead is $2,851. The variable overhead cost is $.55 per figurine. Sales price for the replicas is $5.25 each and the sales price for the dolls is $5.00 each. Required: (For each independent question, refer to the original information above.) A. Compute the break-even point in Year 3 for the figurines. How many dolls and how many replicas must be sold to break-even? B. What options does MI have to reduce the break-even point? Discuss both the quantitative and qualitative factors that must be considered with each option. C. How many dolls and replicas, respectively, would MI need to sell in Year 3 to earn a before-tax profit of $150,000? D. If its tax rate is 30 percent, how many figurines does MI need to sell in Year 3 to earn an after-tax profit of $150,000? E. How will the break-even point change if the sales mix changes to 80 percent dolls and 20 percent replicas? F. What would happen to the break-even point if labor costs increased by 10 percent for each type of figurine? G. What would happen to the break-even point if MI increased the sales price of replicas to $5.50 and dolls to $5.25? Part Six (Special Order) In March of Year 3, Memories, Inc. receives a special order from a local museum to purchase 5,000 dolls and 3,000 replicas for a special exhibit. Required: A. Assuming that MI has sufficient excess capacity, what is the minimum price the company would be willing to accept for this special order? Assuming that the company does not have sufficient excess capacity, what minimum price would be acceptable? What qualitative factors should MI consider when deciding whether to accept the special order? B. MI is nearing its manufacturing capacity and needs to consider ways to increase throughput. What options does the company have to increase capacity? What bottlenecks does it face? What recommendations would you make? Part Seven (Budgets) Memories, Inc., needs a cash budget for Year 3 and has provided you with the following information. Sales are all on account (no cash) and are estimated to be collected over a three-month period, with 70 percent collected in the month of sale, 25 percent collected in the next month, and 4 percent collected in the third month. The remaining 1 percent is estimated to be uncollectible. December and November sales from Year 2 were $201,638 and $185,000, respectively. Because of the lag in collecting cash from sales on account, MI delays payment on some of its purchases of materials. MI estimated that 60 percent of each month's material purchases are paid in the month of purchase and 40 percent in the following month. The accounts payable balance for materials at the end of Year 2 was $20,000. MI requires a minimum balance of $40,000 in cash at the end of each month. The company will use its line of credit when needed to bring the balance up to that minimum level. For any money borrowed, the interest rate is 6 percent compounded annually. For simplicity, you can assume that cash is borrowed on the first day of the month and that loan repayments are made at the end of the month. The loan payable balance at the end of Year 2 was zero. The cash balance at the end of Year 2 was $40,000. Memories, Inc. plans to exercise the option on the leased production equipment in March (see Part Seven). The purchase price on the equipment will be $153,450 with payments of $3,260.36 per month. MI also plans on expanding the existing production space in May at a cost of $200,000. The company would like to finance the expansion out of current earnings and so will use the line of credit, if necessary, in May. The expansion will cause fixed manufacturing overhead to increase by $10,000 per month, starting in May. To remind you, the following costs still hold: Direct material costs $.74 per doll and $.62 per replica Direct labor costs $2.51 per doll and $2.78 per replica Fixed selling and admin costs $15,300 per month Fixed manufacturing overhead costs $2,851 per month Variable overhead costs $.55 per figurine Sales price $5.00 per doll and $5.25 per replica Required: A. Prepare a cash receipts budget for Year 3, assuming estimated sales of 385,000 dolls and 30,000 replicas. The following chart shows the monthly distribution of these sales: January February March April May June 8.3% 9.2% 10.3% 7.6% 8.0% 6.9% July August September October November December 8.5% 9.8% 7.5% 9.1% 7.2% 7.6% B. Prepare a cash disbursements budget for Year 3. C. Prepare a summary cash budget for Year 3, showing any borrowing and repayment of debt with interest. D. Discuss the company's ability to repay the expansion loan. Include a discussion of the feasibility of the project. Include qualitative factors to be considered. E. What if the sales forecast was increased by 50 percent? What impact does that have on the budget, and what is the potential impact on the company? (Prove your answer by rerunning your budgets with the new amounts. If you set up your spreadsheet correctly, this should take two seconds.) Part Eight (Variances) In December of Year 2 operations (month 24), Memories, Inc. actually produced and sold 32,675 figurines, consisting of 30,570 dolls and 2,105 replicas. The budgeted sales price for dolls was $5.00, and $5.25 for replicas. The estimated production and sales during December was 31,678 dolls and 2,595 replicas. Required: A. Compute the price and volume variances for sales, assuming that MI sold all figurines produced for $137,565 (dolls) and $9,051 (replicas). What might explain these variances? B. Compute the price and quantity variances for direct materials for each type of figurine. MI paid $29,093 to purchase 32,325 units of raw materials for dolls and $1,453 to purchase 2,401 units of raw materials for replicas. (A unit consists of plastic, molds, varnish, paint, and packaging materials.) From the materials purchased, 30,995 units were used to produce the dolls and 2,149 were used to produce the replicas. How would these variances be interpreted? What might have caused them? Would you consider them large enough to be important? C. Compute the labor rate and efficiency variances for each type of figurine. MI paid $71,350 in labor costs for 7,150 direct labor hours for dolls and $6,425 in labor costs for 650 direct labor hours for replicas. How would these variances be interpreted? What might have caused them? Would you consider them large enough to be important? D. Assuming MI used a predetermined overhead rate of $2.13 per DLH, compute the variable overhead rate and efficiency variances. MI actually paid $20,852 in total overhead costs, consisting of $17,002 of variable overhead and $3,850 of fixed overhead. How would these variances be interpreted? What might have caused them? Would you consider them large enough to be important? E. How might MI extend its variance analysis to be compatible with activity-based costing if they decided to switch to that method? Part Nine (Transfer Pricing) Memories, Inc. has decided to create a wholly owned subsidiary, Memories Boutique, Inc., (MBI) to sell the figurines directly to the public. In the store dolls will sell for $10.00 each and replicas for $11.50. The intent is for the boutique to buy the figurines directly from Memories, Inc. at the wholesale prices. Assume that MI has excess capacity and can supply the figurines to MBI without impacting their current sales. The manager of MBI has now found an unrelated supplier that will provide dolls for $4.55 and replicas for $5.75. Required: A. Using estimated cost data for Year 3 (given in Part Eight), at what minimum price should MI agree to transfer dolls and replicas to MBI? B. What is the maximum price that MBI should be willing to pay MI for the figurines? C. If MBI purchases figurines from MI, what is the ideal transfer price? Why? D. Should MBI buy figurines from MI or from the outside supplier? (Don't forget that MBI is a wholly owned subsidiary.) What qualitative factors should be considered in making this decision? E. Answer questions A through D again assuming MI is operating at full capacity. Part Ten (NPV) Memories, Inc. currently leases its equipment from Quality Materials, Inc. for $2,500 per month. Two years of their contracted five-year lease term remain. MI may terminate the lease at any time by paying a penalty of $10,000. They are considering purchasing the equipment from Quality Materials, Inc. to replace the leased equipment. MI must purchase 10 units of each piece of equipment. Memories, Inc. can purchase equipment at the following prices: Equipment Heater Injection molder Sealer Cardboard cutter Label installer Price per unit $ 2,100 $ 5,450 $ 4,100 $ 2,695 $ 1,000 Required: A. Using NPV analysis, compare the present value of the least payments with the cost of buying the equipment. Assume a discount rate of 10 percent (ignore tax.) Which option is preferable? B. MI has the option of purchasing equipment from another supplier at a total cost of $190,000. The supplier promises that the new equipment will reduce operating costs by $1,000 per month over the life of the equipment. Assume a 10 percent discount rate (ignore tax.) Which option is preferable? C. Calculate the after-tax NPV for each option in A and B assuming a 30 percent tax rate. If purchased, all equipment will be depreciated over five years, using straight-line depreciation, and will have no salvage value. Which of the three options is preferable now? (Lease, Purchase from Quality Materials, Purchase for $190,000) D. What factors other than cost savings should MI consider in these decisionsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started