Chapter 28, Problem 2R

In the last few months, the company you work for has grown 43%. Up until now, payroll has been managed manually using Excel spreadsheets. To increase efficiency and ease of payroll management, the decision has been made to purchase an off-the-shelf software solution. How would you decide what criteria was needed and which solution would work best for your organization?

CodeHead Software Inc. does software development. One important activity in software development is writing software code. The manager of the WordPro Development Team determined that the average software programmer could write 25 lines of code in an hour. The plan for the first week in May called for 4,650 lines of code to be written on the WordPro product. The WordPro Team has five programmers. Each programmer is hired from an employment firm that requires temporary employees to be hired for a minimum of a 40-hour week. Programmers are paid 32.00 per hour. The manager offered a bonus if the team could generate more lines for the week, without overtime. Due to a project emergency, the programmers wrote more code in the first week of May than planned. The actual amount of code written in the first week of May was 5,650 lines, without overtime. As a result, the bonus caused the average programmers hourly rate to increase to 40.00 per hour during the first week in May. Instructions 1. If the team generated 4,650 lines of code according to the original plan, what would have been the labor time variance? 2. What was the actual labor time variance as a result of generating 5,650 lines of code? 3. What was the labor rate variance as a result of the bonus? 4. The manager is trying to determine if a better decision would have been to hire a temporary programmer to meet the higher programming demand in the first week of May, rather than paying out the bonus. If another employee was hired from the employment firm, what would have been the labor time variance in the first week? 5. Which decision is better, paying the bonus or hiring another programmer?

Sara is considering whether to open a gadgets shop. She provided you, as a consultant, the following information: Sales of $60,000 and $72,000 are expected for July and August, respectively. All goods are sold on account. The collection pattern for Accounts Receivable is 80 percent in the month of sale and 20 percent in the month following the sale. Purchases of $40,000 and $54,000 are expected for July and August. The payment pattern for purchases is 70 percent in the month of purchase, 30 percent in the month following the purchase. Other monthly expenses are $8,000, which includes $2000 of depreciation. All operating expenses are paid in the month of their incurrence. $2,000 of cash is available on August 1, 2021. Required: Prepare the cash collection budget for the two months ending August 31, 2021 Prepare the cash budget for the two months ending August 31, 2021

Following on from the previous question, it is now the end of August 202X, and you are preparing a management report about the Simple Laptop product (SL-1) produced during the month. Using the weighted average method and the following information, calculate the total manufacturing cost of the units of SL-1 which were completed and transferred out during August 202X. Simple Laptop (SL-1) Cost and Production Data for August 202X: 0 laptops in beginning work in progress Commenced the manufacturing process for 10,000 Laptops 8,000 Laptops were completed and transferred out All materials are added at the beginning of the process On average, the work in progress units were 30% completed with respect to conversion costs Direct material costs for the month totaled $8,100,000 Conversion costs for the month totaled $602,000 Group of answer choices a)  $6,760,000 b)  $6,960,800 c)  $7,040,000 d)  $8,701,000

Traya Corp.'s management keeps track of the time it takes to process orders. During the most recent month, the following average times were recorded per order: Wait time is 10.6 days; Inspection time 0.2 day; Process time 2.6 days; Move time 0.6 days; Queue 3.2 days. a. Compute the throughput time b. Compute the manufacturing cycle efficiency c. What percentage of the production time is spent in non-value added activities? d. Compute the delivery cycle time   With solution pls

In August, Lannister Company introduced a new performance measurement system in manufacturing operations. One of the new performance measures is lead time, which is determined by tagging a random sample of items with a log sheet throughout the mouth. The log sheets recorded the time that the sample items started production and the time that they ended production, as well as all steps in between. At the end of the month, the controller collected the log sheets and calculated the average lead time of the tagged products. This number was reported to central management and was used to evaluate the performance of the plant manager. Because of the poor lead time results reported for August, the plant was under extreme pressure to reduce lead time in September.             The following memo was intercepted by the controller. Date: September 3 To: Hourly Employees From: Plant Manager During last month, you may have noticed that some of the products were tagged with a log sheet. This sheet…

Start with the partial model in the file attached. Marvel Pence, CEO of Marvel’s Renovations, a custom building and repair company, is preparing documentation for a line of credit request from his commercial banker. Among the required documents is a detailed sales forecast for parts of 2020 and 2021:   Sales Labor and Raw Materials May, 2020 $75,000 $80,000 June, 2020 $115,000 $75,000 July, 2020 $145,000 $105,000 August, 2020 $125,000 $85,000 September, 2020 $120,000 $65,000 October, 2020 $95,000 $70,000 November, 2020 $75,000 $30,000 December, 2020 $55,000 $35,000 January, 2021 $45,000 N/A   Estimates obtained from the credit and collection department are as follows: collections within the month of sale, 20%; collections during the month following the sale, 60%; collections the second month following the sale, 25%. Payments for labor and raw materials are typically made during the month following the…

Start with the partial model in the file attached. Marvel Pence, CEO of Marvel’s Renovations, a custom building and repair company, is preparing documentation for a line of credit request from his commercial banker. Among the required documents is a detailed sales forecast for parts of 2020 and 2021:   Sales Labor and Raw Materials May, 2020 $75,000 $80,000 June, 2020 $115,000 $75,000 July, 2020 $145,000 $105,000 August, 2020 $125,000 $85,000 September, 2020 $120,000 $65,000 October, 2020 $95,000 $70,000 November, 2020 $75,000 $30,000 December, 2020 $55,000 $35,000 January, 2021 $45,000 N/A   Estimates obtained from the credit and collection department are as follows: collections within the month of sale, 20%; collections during the month following the sale, 60%; collections the second month following the sale, 25%. Payments for labor and raw materials are typically made during the month following the…

Start with the partial model in the file attached. Marvel Pence, CEO of Marvel’s Renovations, a custom building and repair company, is preparing documentation for a line of credit request from his commercial banker. Among the required documents is a detailed sales forecast for parts of 2020 and 2021:   Sales Labor and Raw Materials May, 2020 $75,000 $80,000 June, 2020 $115,000 $75,000 July, 2020 $145,000 $105,000 August, 2020 $125,000 $85,000 September, 2020 $120,000 $65,000 October, 2020 $95,000 $70,000 November, 2020 $75,000 $30,000 December, 2020 $55,000 $35,000 January, 2021 $45,000 N/A   Estimates obtained from the credit and collection department are as follows: collections within the month of sale, 20%; collections during the month following the sale, 60%; collections the second month following the sale, 25%. Payments for labor and raw materials are typically made during the month following the…