J & R's Outdoor Furniture Manufacturers J&R Outdoor Furniture Manufacturers is owned and operated by twin siblings Joyce Yancy-Tate and Royce Yancey. The company has been in operation for several years and manufactures 3-piece sets of outdoor furniture in a variety of colors and patterns. The company has been quite successful over the past years but has experienced a slow decline in profits for the past couple of quarters, according to reports generated by the administrative staff. A month ago, Joyce, took a leave of absence from the business to take care of her newborn twin Sons. Joyce is the Chief Financial Officer for the Company. An assistant business manager/accountant was hired temporarily to assist the staff in carrying out the accounting and financial duties. The company had been consistently reporting net profits over the years but a decline in profits over the past couple of quarters is quite noticeable. The Yancey twins are troubled by this performance and believe they need an expert to review the company's records and operations. Consequently, they have retained your consulting firm to perform research and evaluation and provide recommendations for improvement and recovery of profitable operations. There is also a need for an improved cash flow management strategy Two distinct areas that you are investigating are manufacturing operations and cash flow management. Details are provided below for both areas. ces) Focus AaBbccbdEe Av Tale Normal No Spacing PART ONE Manufacturing and Budgeting The newly hired business manager/accountant prepared the following income statement for the quarter ended June 30, 2020: J & R's Outdoor Furniture Manufacturers Income Statement For the Second Quarter Ended June 30, 2020 Sales Revenue (2,500 sets @ $900) $2,250,000 Operating Expenses Raw Material Purchases Advertising Indirect labor Direct Labor Selling and Adm. Salaries Utilities expense Rent-Factory Building Insurance expense Depreciation-Factory equipment Depreciation Sales equipment $792,000 270,000 84,000 570,000 225,000 58,000 250,000 45,000 91,000 135,000 Total Sell/Admin Expenses 2,520,000 Net Income (Loss) ($270,000) Royce is greatly disturbed by these reported results. The company had been reporting profit in prior quarters. Consequently, he and Joyce agreed to retain you as a consultant and have asked you to review the income statement and recommend any needed corrections and adjustments. You talked with the administrative staff and obtained the following additional data: A. Inventory Data April 1 June 30 Raw Material $48,000 $153,000 Work-in-Progress 72.000 84,000 Finished Goods 90,000 144,000 B. Fifty percent (50%) of the utility expense and sixty-six and two-thirds percent (66 2/3%) of the insurance expense are to be applied to the factory. The remaining amounts are to be considered selling and administrative expenses. REQUIRED Based on your assessment, the following schedule and financial statement are to be prepared and revised, respectively, in the proper format. 1. A detailed schedule of cost of goods sold for the quarter ended June 30, 2020 2. A corrected multi-step income statement for the quarter ended June 30, 2020. (See format in Exhibit #1) PART TWO Cash flow and Financing Before leaving, Joyce advised Royce that there is a need for better forecasting regarding the company's cash inflows and outflows. After a series of questions, you determined that (1) the company had not prepared a cash budget for several quarters and (2) is not up to date on its payables and receivables. You are going to prepare a forecasted income statement and a forecasted cash budget for the fourth quarter. Pertinent information needed has been collected and is outlined below. Pertinent Information: The business manager/accountant and Royce provided projections pertaining to the 2nd quarter (April through June 2020) and other information outlined below: 1. Total sales 2nd quarter: 2,500 3-piece set. Sales price is $900/3-piece set 2. Total Sales for the 3rd quarter are projected to increase 8.5% above the 2nd quarter total sales due to an aggressive marketing program that began June 1, 2020. Total quarter sales per month are expected to be realized as follows: 40% in July 35% in August, and 25% in September. The sales budgets expressed in sales dollars and in the number of furniture sets sold are as follows: July August September TOTAL QTR PROJECTED SALES REVENUE SALES 8.5% increase) $610,313 $854,438 $976,500 $2,441,250 SALES: PRICE X QUANTITY $610,313 $854,438 $976,500 $2,441,250 Number of Furniture Sets Sold July August September TOTAL QTR Number of Furniture Sets Sold 678 949 1 ORS 7713 States Aa BbCcDc Heading 1 Mailings Review View References Table Design Layout Tell me Aa v A 21 T AaBbCcDdEe AaBbCcDdEe Normal No Spacing DA preparcu courrouueror severarquarters and T713 cup water peyouicon Teleraules. You are going to prepare a forecasted income statement and a forecasted cash budget for the fourth quarter. Pertinent information needed has been collected and is outlined below. Pertinent Information: The business manager/accountant and Royce provided projections pertaining to the 2nd quarter (April through June 2020) and other information outlined below: 1. Total sales 2nd quarter: 2,500 3-piece set: Sales price is $900/3-piece set 2. Total Sales for the 3rd quarter are projected to increase 8.5% above the 2nd quarter total sales due to an aggressive marketing program that began June 1, 2020. Total quarter sales per month are expected to be realized as follows: 40% in July 35% in August, and 25% in September. The sales budgets expressed in sales dollars and in the number of furniture sets sold are as follows: July August September TOTAL QTR PROJECTED SALES REVENUE SALES 8.5% increase) $610,313 $854,438 $976,500 $2,441,250 SALES: PRICE X QUANTITY $610,313 $854,438 $976,500 $2,441,250 Number of Furniture Sets Sold July August September TOTAL QTR Number of Furniture Sets Sold 678 949 1,085 2.713 3. Monthly Sales are classified as follows and realized in corresponding percentage: a. Cash sales.... 35% of total sales b. Credit sales... ..65% of total sales 4. Monthly credit sales are collected as follows and in the corresponding proportion: a. Collected in the month of the sale, 60% b. Collected one month after the sale month, 25% C. Collected the second month after the sale month, 15% View Review Table Design Layout Tell me References Mailings A 1 AaBbcodle AaBbCcDdEe Aa v AaBbCcDc AaBbc :::... = = 1 Normal No Spacing Head Heading 1 A V 5. Cost Classifications based on 2nd quarter 2020 information: Fixed Costs Costs Variable Costs Raw Materials used in Manufacturing (See corrected COGS Schedule in Part 1, Required 81) $ ? Actual 2nd Quarter Income Statement Direct Labor 570,000 Overhead: Rent Factory Indirect Labor 84,000 Insurance - Factory (66 2/3%) Utility-Factory (50%) 20,000 Depreciation-factory building $ 250,000 30,000 9,000 91,000 General Administrative Advertising Selling & Administrative Wages and Salaries Utility-Selling & Administrative (50%) Insurance-Administrative (33 2/3%) Depreciation Administrative 90,000 20,000 270,000 135,000 9,000 15,000 135,000 6. All factory overhead and administrative expenses (except depreciation) are paid in cash in the month the cost is incurred. 7. Direct labor is paid at the end of the month 8. Raw material purchases are paid as follows: 60% in the month of the purchase. 20% the month after the purchase, and 20% in the second month following the purchase. The raw materials budget is as follows: PROJECTED July August September TOTAL QTR RAW MATERIAL PURCHASES NEEDED FOR SALES DECIDE ENDING $186,349 06 527 $260,888 66 229 $298,158 74 EAN $745,395 ed States Joyce_Royce_REVISED 2021 1 References Layout Mailings Review View Table Design Tell me Layout V AaBCCD Heading 1 ' ' Aa Ao EE 21 AaBbccbdte AabbCcDdEe Normal Abu No Spacing 7. Direct labor is paid at the end of the month 8. Raw material purchases are paid as follows: 60% in the month of the purchase, 20% the month after the purchase, and 20% in the second month following the purchase. The raw materials budget is as follows: PROJECTED July August September TOTAL QTR RAW MATERIAL PURCHASES $745,395 NEEDED FOR SALES DESIRED ENDING LESS: BEGINNING PURCHASES $186,349 46,587 (153,000) $79,936 $260,888 65,222 (46,587) $279,523 $298,158 74,540 (65,222) $307 475 $666,935 9. Additional monthly obligation paid in cash include: a. Property taxes, due August 31, $2,950. 5 b. Employee payroll taxes due September 30, $3,000, You have determined that you are going to provide the following information to Joyce and Royce: 2. Compute the unit cost of goods sold using 2 quarter information and the corrected cost of goods sold statement you prepared in Part One b. Prepare a projected traditional multi-step Income statement for the 34 quarter using information in "," above and the 2 quarter information on the table in "S" above (see the previous page). For proper formatting see Exhibit 1 at the end of this document, Joyce_Royce_REVISED 2021 References Mailings Review View Table Design Layout Tell me A AL T AaBbCcDdEe AaBbCcDdEe Aa BbccDc AaBbcc Normal No Spacing Heading 1 Headin A V b. Employee payroll taxes due September 30, $3,000, You have determined that you are going to provide the following information to Joyce and Royce: a. Compute the unit cost of goods sold using 2nd quarter information and the corrected cost of goods sold statement you prepared in Part One b. Prepare a projected traditional multi-step Income statement for the 3rd quarter using information in "a," above and the 2nd quarter information on the table in "5" above (see the previous page). For proper formatting, see Exhibit 1 at the end of this document. c. Prepare a schedule of projected cash collections from credit sales for each month of the 3rd quarter Relevant prior months' credit sales: May credit sales. $368,720 June credit sales, $331,840 d. Prepare a schedule of projected cash payments for raw materials for each month of the 3rd quarter. Relevant prior months credit (on account) purchases: May purchases on account. $344,100 June purchases on account, $309,720 e. Prepare a projected cash budget for the total 3 quarter. Your budget should include a monthly budget for each of the three months in the quarter. The cash balance on July 1, 2020 is $1,270,000. J & R's Outdoor Furniture Manufacturers J&R Outdoor Furniture Manufacturers is owned and operated by twin siblings Joyce Yancy-Tate and Royce Yancey. The company has been in operation for several years and manufactures 3-piece sets of outdoor furniture in a variety of colors and patterns. The company has been quite successful over the past years but has experienced a slow decline in profits for the past couple of quarters, according to reports generated by the administrative staff. A month ago, Joyce, took a leave of absence from the business to take care of her newborn twin Sons. Joyce is the Chief Financial Officer for the Company. An assistant business manager/accountant was hired temporarily to assist the staff in carrying out the accounting and financial duties. The company had been consistently reporting net profits over the years but a decline in profits over the past couple of quarters is quite noticeable. The Yancey twins are troubled by this performance and believe they need an expert to review the company's records and operations. Consequently, they have retained your consulting firm to perform research and evaluation and provide recommendations for improvement and recovery of profitable operations. There is also a need for an improved cash flow management strategy Two distinct areas that you are investigating are manufacturing operations and cash flow management. Details are provided below for both areas. ces) Focus AaBbccbdEe Av Tale Normal No Spacing PART ONE Manufacturing and Budgeting The newly hired business manager/accountant prepared the following income statement for the quarter ended June 30, 2020: J & R's Outdoor Furniture Manufacturers Income Statement For the Second Quarter Ended June 30, 2020 Sales Revenue (2,500 sets @ $900) $2,250,000 Operating Expenses Raw Material Purchases Advertising Indirect labor Direct Labor Selling and Adm. Salaries Utilities expense Rent-Factory Building Insurance expense Depreciation-Factory equipment Depreciation Sales equipment $792,000 270,000 84,000 570,000 225,000 58,000 250,000 45,000 91,000 135,000 Total Sell/Admin Expenses 2,520,000 Net Income (Loss) ($270,000) Royce is greatly disturbed by these reported results. The company had been reporting profit in prior quarters. Consequently, he and Joyce agreed to retain you as a consultant and have asked you to review the income statement and recommend any needed corrections and adjustments. You talked with the administrative staff and obtained the following additional data: A. Inventory Data April 1 June 30 Raw Material $48,000 $153,000 Work-in-Progress 72.000 84,000 Finished Goods 90,000 144,000 B. Fifty percent (50%) of the utility expense and sixty-six and two-thirds percent (66 2/3%) of the insurance expense are to be applied to the factory. The remaining amounts are to be considered selling and administrative expenses. REQUIRED Based on your assessment, the following schedule and financial statement are to be prepared and revised, respectively, in the proper format. 1. A detailed schedule of cost of goods sold for the quarter ended June 30, 2020 2. A corrected multi-step income statement for the quarter ended June 30, 2020. (See format in Exhibit #1) PART TWO Cash flow and Financing Before leaving, Joyce advised Royce that there is a need for better forecasting regarding the company's cash inflows and outflows. After a series of questions, you determined that (1) the company had not prepared a cash budget for several quarters and (2) is not up to date on its payables and receivables. You are going to prepare a forecasted income statement and a forecasted cash budget for the fourth quarter. Pertinent information needed has been collected and is outlined below. Pertinent Information: The business manager/accountant and Royce provided projections pertaining to the 2nd quarter (April through June 2020) and other information outlined below: 1. Total sales 2nd quarter: 2,500 3-piece set. Sales price is $900/3-piece set 2. Total Sales for the 3rd quarter are projected to increase 8.5% above the 2nd quarter total sales due to an aggressive marketing program that began June 1, 2020. Total quarter sales per month are expected to be realized as follows: 40% in July 35% in August, and 25% in September. The sales budgets expressed in sales dollars and in the number of furniture sets sold are as follows: July August September TOTAL QTR PROJECTED SALES REVENUE SALES 8.5% increase) $610,313 $854,438 $976,500 $2,441,250 SALES: PRICE X QUANTITY $610,313 $854,438 $976,500 $2,441,250 Number of Furniture Sets Sold July August September TOTAL QTR Number of Furniture Sets Sold 678 949 1 ORS 7713 States Aa BbCcDc Heading 1 Mailings Review View References Table Design Layout Tell me Aa v A 21 T AaBbCcDdEe AaBbCcDdEe Normal No Spacing DA preparcu courrouueror severarquarters and T713 cup water peyouicon Teleraules. You are going to prepare a forecasted income statement and a forecasted cash budget for the fourth quarter. Pertinent information needed has been collected and is outlined below. Pertinent Information: The business manager/accountant and Royce provided projections pertaining to the 2nd quarter (April through June 2020) and other information outlined below: 1. Total sales 2nd quarter: 2,500 3-piece set: Sales price is $900/3-piece set 2. Total Sales for the 3rd quarter are projected to increase 8.5% above the 2nd quarter total sales due to an aggressive marketing program that began June 1, 2020. Total quarter sales per month are expected to be realized as follows: 40% in July 35% in August, and 25% in September. The sales budgets expressed in sales dollars and in the number of furniture sets sold are as follows: July August September TOTAL QTR PROJECTED SALES REVENUE SALES 8.5% increase) $610,313 $854,438 $976,500 $2,441,250 SALES: PRICE X QUANTITY $610,313 $854,438 $976,500 $2,441,250 Number of Furniture Sets Sold July August September TOTAL QTR Number of Furniture Sets Sold 678 949 1,085 2.713 3. Monthly Sales are classified as follows and realized in corresponding percentage: a. Cash sales.... 35% of total sales b. Credit sales... ..65% of total sales 4. Monthly credit sales are collected as follows and in the corresponding proportion: a. Collected in the month of the sale, 60% b. Collected one month after the sale month, 25% C. Collected the second month after the sale month, 15% View Review Table Design Layout Tell me References Mailings A 1 AaBbcodle AaBbCcDdEe Aa v AaBbCcDc AaBbc :::... = = 1 Normal No Spacing Head Heading 1 A V 5. Cost Classifications based on 2nd quarter 2020 information: Fixed Costs Costs Variable Costs Raw Materials used in Manufacturing (See corrected COGS Schedule in Part 1, Required 81) $ ? Actual 2nd Quarter Income Statement Direct Labor 570,000 Overhead: Rent Factory Indirect Labor 84,000 Insurance - Factory (66 2/3%) Utility-Factory (50%) 20,000 Depreciation-factory building $ 250,000 30,000 9,000 91,000 General Administrative Advertising Selling & Administrative Wages and Salaries Utility-Selling & Administrative (50%) Insurance-Administrative (33 2/3%) Depreciation Administrative 90,000 20,000 270,000 135,000 9,000 15,000 135,000 6. All factory overhead and administrative expenses (except depreciation) are paid in cash in the month the cost is incurred. 7. Direct labor is paid at the end of the month 8. Raw material purchases are paid as follows: 60% in the month of the purchase. 20% the month after the purchase, and 20% in the second month following the purchase. The raw materials budget is as follows: PROJECTED July August September TOTAL QTR RAW MATERIAL PURCHASES NEEDED FOR SALES DECIDE ENDING $186,349 06 527 $260,888 66 229 $298,158 74 EAN $745,395 ed States Joyce_Royce_REVISED 2021 1 References Layout Mailings Review View Table Design Tell me Layout V AaBCCD Heading 1 ' ' Aa Ao EE 21 AaBbccbdte AabbCcDdEe Normal Abu No Spacing 7. Direct labor is paid at the end of the month 8. Raw material purchases are paid as follows: 60% in the month of the purchase, 20% the month after the purchase, and 20% in the second month following the purchase. The raw materials budget is as follows: PROJECTED July August September TOTAL QTR RAW MATERIAL PURCHASES $745,395 NEEDED FOR SALES DESIRED ENDING LESS: BEGINNING PURCHASES $186,349 46,587 (153,000) $79,936 $260,888 65,222 (46,587) $279,523 $298,158 74,540 (65,222) $307 475 $666,935 9. Additional monthly obligation paid in cash include: a. Property taxes, due August 31, $2,950. 5 b. Employee payroll taxes due September 30, $3,000, You have determined that you are going to provide the following information to Joyce and Royce: 2. Compute the unit cost of goods sold using 2 quarter information and the corrected cost of goods sold statement you prepared in Part One b. Prepare a projected traditional multi-step Income statement for the 34 quarter using information in "," above and the 2 quarter information on the table in "S" above (see the previous page). For proper formatting see Exhibit 1 at the end of this document, Joyce_Royce_REVISED 2021 References Mailings Review View Table Design Layout Tell me A AL T AaBbCcDdEe AaBbCcDdEe Aa BbccDc AaBbcc Normal No Spacing Heading 1 Headin A V b. Employee payroll taxes due September 30, $3,000, You have determined that you are going to provide the following information to Joyce and Royce: a. Compute the unit cost of goods sold using 2nd quarter information and the corrected cost of goods sold statement you prepared in Part One b. Prepare a projected traditional multi-step Income statement for the 3rd quarter using information in "a," above and the 2nd quarter information on the table in "5" above (see the previous page). For proper formatting, see Exhibit 1 at the end of this document. c. Prepare a schedule of projected cash collections from credit sales for each month of the 3rd quarter Relevant prior months' credit sales: May credit sales. $368,720 June credit sales, $331,840 d. Prepare a schedule of projected cash payments for raw materials for each month of the 3rd quarter. Relevant prior months credit (on account) purchases: May purchases on account. $344,100 June purchases on account, $309,720 e. Prepare a projected cash budget for the total 3 quarter. Your budget should include a monthly budget for each of the three months in the quarter. The cash balance on July 1, 2020 is $1,270,000