Taylor Family Case Study Anne Taylor is preparing the 2022 budget for one of Second designs...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Taylor Family Case Study Anne Taylor is preparing the 2022 budget for one of Second designs yacht. Extensive meetings with members of the sales department and executive management have resulted in the following unit sales projections for 2022. For quarter 1 the projected sales are 1000 yacht and each quarter the number increases by 10% from the previous quarter. They expect to sell each yacht for $100 in quarter one and a 20% increase in each quarter to previous after that. Second designs policy is to have finished goods inventory in a quarter equal to 20% of the next quarters anticipated Sales. Preliminary Sales projections for 2023 are 500 yachts for the first quarter and 600 yachts for the second quarter. Ending finished goods at December 2021 are 300 yachts. Production of each yacht requires 50 pounds of actetic powder and one finishing kit (seat, engine, metal etc). Company policy is that the ending inventory for actetic should be 25% of the amount needed in production for the next quarter. Assume that the ending inventory of actetic in December 2022 is 12000 pounds and for the first quarter in 2023 is 14000 pounds. The finishing kit can be assembled as they are needed based on production. As a result Roberts family does not maintain a significant inventory (opening and closing) of the finishing kits. The actetic powder used in the production of the yacht cost $1.50 per pound and the finishing kit costs $170 each. Production of a single yacht required 3 hours of work by employees. Employees are paid $15 per hour. Selling and administrative are expected to be $45 per unit sold plus $7500 per quarter. Manufacturing overhead is assigned at 150% of labour costs and additional fixed costs of $500 for depreciation and $300 for maintenance costs each quarter. Interest per quarter are expected to be $200 and taxes $400 per quarter. Overheads are measured by direct labour hour. Requirements Prepare the sales budget, production budget, direct material budget, labour budget, manufacturing overhead budget, selling and administrative budget for each quarter for the year 2022 and prepare a Budgeted Income Statement for the year 2022. Your answer to be completed on an Excel sheet using formulas rather than a calculator Your answer (Excel File) must be uploaded on Blackboard by 8th December 11.59pm. Any figures can be rounded up if needed Taylor Family Case Study Anne Taylor is preparing the 2022 budget for one of Second designs yacht. Extensive meetings with members of the sales department and executive management have resulted in the following unit sales projections for 2022. For quarter 1 the projected sales are 1000 yacht and each quarter the number increases by 10% from the previous quarter. They expect to sell each yacht for $100 in quarter one and a 20% increase in each quarter to previous after that. Second designs policy is to have finished goods inventory in a quarter equal to 20% of the next quarters anticipated Sales. Preliminary Sales projections for 2023 are 500 yachts for the first quarter and 600 yachts for the second quarter. Ending finished goods at December 2021 are 300 yachts. Production of each yacht requires 50 pounds of actetic powder and one finishing kit (seat, engine, metal etc). Company policy is that the ending inventory for actetic should be 25% of the amount needed in production for the next quarter. Assume that the ending inventory of actetic in December 2022 is 12000 pounds and for the first quarter in 2023 is 14000 pounds. The finishing kit can be assembled as they are needed based on production. As a result Roberts family does not maintain a significant inventory (opening and closing) of the finishing kits. The actetic powder used in the production of the yacht cost $1.50 per pound and the finishing kit costs $170 each. Production of a single yacht required 3 hours of work by employees. Employees are paid $15 per hour. Selling and administrative are expected to be $45 per unit sold plus $7500 per quarter. Manufacturing overhead is assigned at 150% of labour costs and additional fixed costs of $500 for depreciation and $300 for maintenance costs each quarter. Interest per quarter are expected to be $200 and taxes $400 per quarter. Overheads are measured by direct labour hour. Requirements Prepare the sales budget, production budget, direct material budget, labour budget, manufacturing overhead budget, selling and administrative budget for each quarter for the year 2022 and prepare a Budgeted Income Statement for the year 2022. Your answer to be completed on an Excel sheet using formulas rather than a calculator Your answer (Excel File) must be uploaded on Blackboard by 8th December 11.59pm. Any figures can be rounded up if needed
Expert Answer:
Answer rating: 100% (QA)
Anne Taylor Budgets for the year 2022 Quarterwise Sales Budget Quarter 1 Quarter 2 Quarter 3 100000 ... View the full answer
Posted Date:
Students also viewed these accounting questions
-
Using the information provided in Problem 9, discuss all transaction listings and summary reports that would be necessary for a batch system with real-time input of data.
-
Using the information provided in Exercise 1 above, how large a sample size should be taken to estimate the proportion of all Canadian grocery shoppers who are trying to make healthier food choices...
-
Using the information provided in E8- 15, assume Bailey uses the completed-contract method. Prepare the journal entries required in each year to record the contract (show all supporting...
-
Think about the impact that e-commerce and more flexible networks of organisations has had on the way international business is conducted. How has it created new complexities in the relationships...
-
(a) The portfolio manager of a tax-exempt fund is considering investing $500,000 in a debt instrument that pays an annual interest rate of 5.7% for four years. At the end of four years, the portfolio...
-
On January 1, 2014, Alphabet Company leased an office building to Numbers, Inc. The relevant information related to the lease is as follows. 1. The lease arrangement is for 16 years. 2. The leased...
-
Explain why the sample variance formula is \[\sum_{i=1}^{N} \frac{\left(y_{i}-\bar{y} ight)^{2}}{N-1}\] instead of \[\sum_{i=1}^{N} \frac{\left(y_{i}-\bar{y} ight)^{2}}{N}\]
-
Duval Ford, LLC, sold a new Ford F-250 pick-up truck to David Sweat. Before taking delivery, Sweat ordered a lift kit to be installed on the truck by a Duval subcontractor. Sweat also replaced the...
-
What is the future value of annuity (FVA) that has annual payments of $30,000 for 15 years if the annual interest rate is 7%? Reference the following formulas to solve the problem: FV=PV/(1+r)^t...
-
1. Mr. Albert has a piece of property he has used in his business for 25 years. He is moving his business across the country and needs to get rid of the real estate he currently owns, as he won't be...
-
You access financial information on the restaurant's sales, gross profits and expenses. You identify that the restaurant is spending too much money on food costs and need to identify opportunities to...
-
4) Differentiate by using the product and the quotient formula: (a) z(u) = (u + 1)(2u - 4u-1) (x+2) (b) y = 1-x
-
2. Find the following limits: lim (x-3) *** 3
-
The veterinarian suspects a bleeding disorder in a young mixed breed dog. He requests that you perform a BMBT test on the dog. What other piece of information is necessary with any coagulation test?
-
Solve the formula 8 x 3 y = - 1 9 for y .
-
given l o g x 5 = l o g 5 x solve for x
-
the sales agreement that Alpha Company signed for job ABC indicated that the selling price for the job would be cost plus 150% a. What is the price per unit using the unit product cost is $80 b. What...
-
Dr. Chan obtained a $15,000 demand loan at prime plus 1.5% on September 13 from the Bank of Montreal to purchase a new dental X-ray machine. Fixed payments of $700 will be deducted from the dentists...
-
Near the state capitol, a heritage center houses historical artifacts of significance to the state dating from pre-statehood to the present. The center is particularly well done and serves as both a...
-
Opponents to charging an entrance fee as described in Problem 32 note that only 15,000 visitors will utilize the heritage center, and the benefits of \(\$ 5(14,000)+\$ 3(12,000)=\$ 106,000\) derived...
-
The federal government is planning a hydroelectric project for a river basin. The project will provide electrical energy to the local area and to the grid. With some enhancements to the basic plan,...
Study smarter with the SolutionInn App