J&R Outdoor Furniture Manufacturers is owned and operated by twin siblings Joyce Yancy-Tate and Royce Yancey....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. 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 2d 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. 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 arid in the number of furniture Total quarter sales sets sold are as follows: PROJECTED July August September TOTAL QTR 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 Furmiture 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.. b. Credit sales. 35% of total 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% 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 Work-in-Progress Finished Goods $153,000 $48,000 72,000 84,000 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 good 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 ONE Manufacturing and Budgeting The newly hired business manager/accountant prepared the following income statement for the quart ended June 30, 2020: & R's Outuoor 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 $792,000 Advertising 270,000 Indirect labor 84,000 Direct Labor 570,000 Selling and Adm. Salaries Utilities expense 225,000 58,000 Rent-Factory Building 250,000 Insurance expense 45,000 Depreciation-Factory equipment Depreciation-Sales equipment 91,000 135,000 Total Sell/Admin Expenses 2,540,000 Net Income (Loss) (5270,000) 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. 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 2d 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. 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 arid in the number of furniture Total quarter sales sets sold are as follows: PROJECTED July August September TOTAL QTR 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 Furmiture 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.. b. Credit sales. 35% of total 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% 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 Work-in-Progress Finished Goods $153,000 $48,000 72,000 84,000 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 good 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 ONE Manufacturing and Budgeting The newly hired business manager/accountant prepared the following income statement for the quart ended June 30, 2020: & R's Outuoor 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 $792,000 Advertising 270,000 Indirect labor 84,000 Direct Labor 570,000 Selling and Adm. Salaries Utilities expense 225,000 58,000 Rent-Factory Building 250,000 Insurance expense 45,000 Depreciation-Factory equipment Depreciation-Sales equipment 91,000 135,000 Total Sell/Admin Expenses 2,540,000 Net Income (Loss) (5270,000)
Expert Answer:
Answer rating: 100% (QA)
1computation of cost of Goods sold Direct Material Beginning of material inventory 4800000 Add Purch... View the full answer
Related Book For
Posted Date:
Students also viewed these general management questions
-
The Springfield Clinic is owned and operated by ten local doctors as a partnership. Recently, a paralyzed patient sued the clinic for malpractice, for a total of $20 million. The clinic carries...
-
The Springfield Clinic is owned and operated by ten local doctors as a partnership. Recently, a paralyzed patient sued the clinic for malpractice, for a total of $20 million. The clinic carries...
-
The C'mon Back Restaurant in Puerto Rico is owned and operated by Theotis Jones. The restaurant just completed its third year of operation. During that time, Theotis sought to establish a reputation...
-
The flexural rigidity of a rod-like structure like a microtubule is a measure of its bending stiffness. Flexural rigidity is given by EL, where E is the Young?s modulus and L is the geometrical...
-
An appliance store sold GE coffeemakers for $22.95 during a promotional sale. The store bought the coffeemakers for $36 less 40% and 15%. Overhead is 25% of the regular selling price. (a) If the...
-
Figure 34.21 shows diffracted \(\mathrm{x}\)-ray intensity as a function of the Bragg angle \(\alpha\), obtained using \(\mathrm{x}\) rays having a wavelength of \(0.11 \mathrm{~nm}\). (a) Without...
-
Weekly salaries (in dollars) for a sample of construction workers are listed. (a) Find the mean, median, and mode of the salaries. Which best describes a typical salary? (b) Find the range, variance,...
-
On December 31, 2013, Ogleby Associates owned the following securities that are held as long-term investments. On this date, the total fair value of the securities was equal to its cost. The...
-
Consider a projectile launched with an initial velocity of11.2m/sat an angle of0=21.9above horizontal from a cliff of heighth=11.63m.It travels a horizontal distance,d,before striking the ground at...
-
Sun Valley Rides is a wholesaler of motorcycle supplies. An aging of the companys accounts receivable on December 31, 20Y3, and a historical analysis of the percentage of uncollectible accounts in...
-
Write a C++ Main code the generate random list of numbers. Your main code should test the prime numbers in the list by sending each number to bool Prime1(int k). Your code should also display how...
-
Many researchers are interested in the transcription of protein-encoding genes in eukaryotes. Such researchers want to study mRNA. One method that is used to isolate mRNA is column chromatography....
-
What would happen to the SML graph in Figure 8.8 if expected inflation increased or decreased? Figure 8.8 268 269 270 271 272 273 274 275 A Required Rate of Return TH-13.0% SML: r, RF+RPM * b D E F H...
-
Political expectations, inflation, and unemployment Consider a country with two political parties, Democrats and Republicans. Democrats care more about unemployment than Republicans, and Republicans...
-
A European recession and the U.S. economy a. In 2014, European Union spending on U.S. goods accounted for \(18 \%\) of U.S. exports (see Table 17-2), and U.S. exports amounted to \(15 \%\) of U.S....
-
In general how have interest rates changed since the late 1980s according to Figure 11.1? FIGURE 11.1 Interest and Inflation Rates, 1988-2010 10p Rate (%) 8 6 10-Year Treasury Bonds 4 2 AAA Corporate...
-
Purchase Date Units Items Unit Price Total 1 0 / 1 / XX 2 Candy Bars $ 0 . 2 5 $ 0 . 5 0 1 0 / 1 5 / XX 2 Candy Bars $ 0 . 3 0 $ 0 . 6 0 1 0 / 3 1 / XX 1 Candy Bars $ 0 . 4 0 $ 0 . 4 0 5 Total Cost...
-
For the vector whose polar components are (Vr = 1, Vθ = 0), compute in polars all components of the second covariant derivative Vα;μ;ν. To find...
-
Eurotronics is a European manufacturer of electronic components. During the course of a year, it requires container cargo space on ships leaving Hamburg bound for the United States, Mexico, South...
-
The 23,000-seat City Coliseum houses the local professional ice hockey, basketball, indoor soccer, and arena football teams, as well as various trade shows, wrestling and boxing matches, tractor...
-
The U.S. Army Corps of Engineers has historically constructed dams on various rivers in the southeastern United States. Its primary instrument for evaluating and selecting among many projects under...
-
With reference to Exercise 10.50, test the null hypothesis \(p=0.18\) versus the alternative hypothesis \(p eq 0.18\) at the 0.01 level. Data From Exercise 10.50 10.50 In a random sample of 160...
-
In a random sample of 160 workers exposed to a certain amount of radiation, 24 experienced some ill effects. Construct a \(99 \%\) confidence interval for the corresponding true percentage using the...
-
Refer to Example 5 but suppose there are two additional design plans \(\mathrm{B}\) and \(\mathrm{C}\) for making miniature drones. Under B, 10 of 40 drones failed the initial test and under C 15 of...
Study smarter with the SolutionInn App