Answer these 4 questions in detail based on the Tracking Manufacturing Costs on a Continuous Flow of Identical Products case study and spreadsheet below.

1. On a FIFO basis, what are the percent changes in the cost per completed unit from one group to the next over the three-month period? What may have caused these differences?
2. If the estimate for projected production in August is adjusted down by 20% due to inclement weather, yet total labor and factory overhead costs remain at the original amounts, what is the impact on cost per equivalent unit?
3. At the selling price of US$97.00 per unit, what is the gross profit for July if the packaging department adds US$0.04 to each unit and if units sold are 30,000 in June and 35,000 in July? Explain.
4. Was accepting the licensing requirement as part of the Spark Bank financing deal a good idea? What are the positive and negative aspects of doing so?

Case Study:

Spreadsheet:

INTRODUCTION William Black is a creative, entrepreneurial individual who is constantly working on unique and innovative solutions to everyday problems and annoyances. He has developed several interesting products and even garnered a limited number of online sales. But none of his inventions has taken off-until now. William recently developed an electronic device, BallBoy, which locates golf balls above ground, in ground, and under water. The built-in technology is powerful enough to search for and detect balls within a radius of the length of a soccer field. BallBoy is a holster that holds smart phones of various sizes and models. It is activated once the short cable on the device is plugged into the phone. BallBoy gives walking directions to golf balls visually on the phone screen as well as via audio instructions. BallBoy is inexpensive to produce but, due to its unique design, is difficult to replicate. William is particularly pleased with BallBoy, realizing it is his best idea yet. He has a patent pending to protect the functionality and use of his invention. William and his parents made and packaged 1,500 units of BallBoy in their garage and offered the product for sale online at US $99 per unit. William posted photos, videos, and information about BallBoy on his ecommerce website; the response was overwhelming. Within a week, orders exceeded 3,600 units. He shipped the available units and advised the remaining customers of the backorder. Customers posted rave reviews for quality, value, and functionality. William began hiring employees and expanded into his basement and backyard to scale the size of his operations. Orders continued to roll in at a pace he never imagined, and the team was barely able to keep up with the growing demand. William had neither the capacity nor the capital to further expand his production. He was denied loans at several banks due to his inexperience and unproven financial track record, and his family and friends did not have money to spare. The good news is he was contacted to appear on Spark Bank, a television show where entrepreneurs present new business ideas and products to five self-made billionaires who invest in small businesses they find appealing. On the show, the Spark Bank investors/judges were impressed with BallBoy and its potential to generate significant profit. Mike Peruvian and "Mr. Fantastic" showed genuine interest in William's business concept and offered a 10% equity stake in the business in exchange for funding to finance inventory and establish a production facility. Their one contingency was that after one year of operations, William must license the BallBoy technology to a major manufacturer, which they believe could use it for a different application. William was hesitant about sharing his trade secret, yet he agreed to the deal since he needed to money to proceed. Mike Peruvian wanted to be sure that William was well-versed in process costing as a cost allocation technique for identical items that are manufactured in a continuous sequence. He saw this as a test of William's ability to be a good product manager. He asked William to allocate anticipated production costs for both fully and partially completed units for three consecutive months in the assembly department using the first in, first out (FIFO) method of process costing. Mike expected William to be able to determine the cost for each unit in each of three months, explain how one period's production data feeds into the next in a continuous flow, and analyze the progress of the business over time. Mr. Fantastic's perspective was "Show me the money!" He wanted William to investigate ways to reduce production costs over time to increase profitability. The first month's production costs would be a baseline, and William should locate less expensive suppliers, labor, and/or overhead items to reduce unit costs in the second and third months. This would involve decision points for William, since a change in one cost might impact another cost. William begins by thinking about the production process. He determines that it will be most efficient if he moves materials from the stockroom as infrequently as possible, particularly since there is sufficient space in the production area to stage all materials needed to fully assemble items as they enter the assembly department. He estimates that units will spend no more than three weeks in the assembly department and recognizes that conversion costs will be incurred throughout this period. The first month of operations in the new facility will be June, and William analyzes costs for June, July, and August in his pro-forma analyses. Based on sales projections in good-weather conditions, William estimates he will need to begin production on 41,300 new units in June, 54,200 units in July, and 71,100 units in August. He is aware that the National Weather Service has predicted an extremely active hurricane season, which may adversely impact August and September sales, perhaps indicating a decline in production in August up to 20%. But he decides to proceed with his original August estimate. William realizes that not all of the new units started in a month will be completed the same month. He approximates that 13% of the units started each month will remain in work in process at the end of that month. His target is for 60% of the conversion process to be completed on the unfinished units at the end of each month. He anticipates, however, that in June the learning curve and start-up glitches may make that goal unattainable. Therefore, he conservatively estimates only a 30% completion rate instead. To make up for June's slower-than-average start and bring production back on track in July, he plans to offer employees compensation time incentives to work additional hours to achieve a 90% conversion rate. Over the course of the first two months, the conversion completed will ultimately average 60%, the targeted percentage. The expected number of units and conversion rates are: William also estimates the following expenditures for June: direct materials, US\$716,555; direct labor costs, US\$276,612; and factory overhead, US\$149,520. In July, William projects factory overhead cost per equivalent unit will change, since some initial overhead costs in June pertained to the first month only. He also believes that the materials cost per unit will change due to political decisions regarding the North American Free Trade Agreement (NAFTA). In August, direct labor will likely increase per equivalent unit based on the contractual rate increase after the 60-day probationary period. William chooses the better of the two options regarding materials and overhead in August: Note: All monetary values are represented as US dollars. William develops a spreadsheet to analyze cost data for the three months. For a sample, see Figure 1. ASSIGNMENT 1. a. How much did the materials cost per unit change between June and July? b. How much did the conversion cost per unit change between June and July? 2. Which is the optimal choice of material and factory overhead costs in August? Why? 3. On a FIFO basis, what are the percent changes in the cost per completed unit from one group to the next over the three-month period? What may have caused these differences? 4. How should William respond to Mr. Fantastic's call to "Show me the money!" in terms of options to reduce production costs over time to increase profitability? 5. If the estimate for projected production in August is adjusted down by 20% due to inclement weather, yet total labor and factory overhead costs remain at the original amounts, what is the impact on cost per equivalent unit