You will need to create a new production schedule for 2022 using level production the sales...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You will need to create a new production schedule for 2022 using level production the sales forecast given below. Thrusters has a beginning inventory of 5 units and would like an ending inventory of 9 units. Forecast sales in boards are given below. Oct Nov Dec Jan Feb Mar 27 17 12 12 12 17 Apr May Jun Jul Aug Sep 27 57 72 122 82 67 Your schedules and statements should link to the assumptions. I should be able to change values in your assumptions and have the schedules and statements update. The balance sheet for the beginning of the year is given below: Thruster Corporation Balance sheet 30-Sep-21 Assets Liabilities Cash $ 25,000 Accounts Payable $ 26,400 Accounts receivable 30,000 Line of Credit Inventory 3,600 Long term debt 150.000 Current Assets 58,600 total liabilities 176,400 Stock 80,000 Capital Assets 205,000 Retained eamings 7.200 Total Assets $263,600 and equity $263,600 Additional Information The surfboards sell for $1,000 each. 20% of the sales are cash sales and the remainder are accounts receivable paid the following month. The cost per board is $600 these costs are all paid the month following production ⚫ Fixed costs are $144,000 paid in equal amounts each month. You may use these as selling and admin costs in your template Taxes are 20% you may assume the amount calculated on your income statement is paid in April You will need to create a new production schedule for 2022 using level production the sales forecast given below. Thrusters has a beginning inventory of 5 units and would like an ending inventory of 9 units. Forecast sales in boards are given below. Oct Nov Dec Jan Feb Mar 27 17 12 12 12 17 Apr May Jun Jul Aug Sep 27 57 72 122 82 67 Your schedules and statements should link to the assumptions. I should be able to change values in your assumptions and have the schedules and statements update. The balance sheet for the beginning of the year is given below: Thruster Corporation Balance sheet 30-Sep-21 Assets Liabilities Cash $ 25,000 Accounts Payable $ 26,400 Accounts receivable 30,000 Line of Credit Inventory 3,600 Long term debt 150.000 Current Assets 58,600 total liabilities 176,400 Stock 80,000 Capital Assets 205,000 Retained eamings 7.200 Total Assets $263,600 and equity $263,600 Additional Information The surfboards sell for $1,000 each. 20% of the sales are cash sales and the remainder are accounts receivable paid the following month. The cost per board is $600 these costs are all paid the month following production ⚫ Fixed costs are $144,000 paid in equal amounts each month. You may use these as selling and admin costs in your template Taxes are 20% you may assume the amount calculated on your income statement is paid in April
Expert Answer:
Answer rating: 100% (QA)
Here are the stepbystep calculations without tables Production Schedule October Forecast Sales 27 bo... View the full answer
Related Book For
Financial Accounting and Reporting a Global Perspective
ISBN: 978-1408076866
4th edition
Authors: Michel Lebas, Herve Stolowy, Yuan Ding
Posted Date:
Students also viewed these accounting questions
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
You have completed your first meeting with Harper and Riley Evans. You are confident that you now have most of the information you will need to prepare a comprehensive financial plan for them. Beyond...
-
Assuming 10% minimum required reserve ratio, 5% excess reserve ratio, and people holding 10% of cash received at home (not deposited in the banks), the money multiplier is equal to Select one: a....
-
1. Prepare Boston Cycle's perpetual inventory record assuming the company uses the specific identification inventory costing method. Assume that Boston sold 10 bicycles that cost $42 each and 24...
-
Galinha-Esquina SA grows and processes chickens. Each chicken is disassembled into five main parts. Information pertaining to production in July 2018 is as follows: Joint costs of production in July...
-
Identify and describe the key attributes that might mitigate a red flag, suggesting that no bad act or compliance issues exist.
-
Retail Inventory Method Presented below is information related to McKenna Company. (a) Compute the ending inventory at retail. (b) Compute a cost-to-retail percentage (round to two decimals) under...
-
6. Some particles (certain atomic nuclei, and certain mediating particles) have spin 1. This means that in a Stern-Gerlach experiment they yield three measurements: h, 0, -h. This means that now we...
-
The trial balance of Escobedo Company as of January 31, 20X1, after the company completed the first month of operations, is shown in the partial worksheet below. INSTRUCTIONS Complete the worksheet...
-
Can you explain what Cp & Cpk are?
-
The weak form of the efficient market hypothesis states that a.successive price changes are biased. b.successive price changes are independent. c.successive price changes depend on trading...
-
(+5) Determine the output Q, in terms of the inputs A B, by filling in the table below (the Q column should only consist of a 1 or 0 + A+ 0 04 1+ 1+ A .8- B 0+ 14 0+ 1+ Qu P ts t t t P P P 2 -.0
-
4. Consider the following set of functional dependencies on the relation schema R = (A, B, C, D, E, F, G): a) Find all candidate keys for R ABCDF BDCF B D E A DF G b) Remove extraneous attributes...
-
For each of the following sub-problems, output your results in an fprintf statement outside of your Matlab function files. Comment on the results you find. Do they make sense? Note, it may be a good...
-
Oil futures have a 1000 barrel contract size and an 8% initial margin requirement. If an investor takes a long position in one contract when the futures price is $32/barrel, what will be that...
-
The pump of a water distribution system is powered by a 15-kW electric motor (efficiency = 90%). For the pump, (i) water flow rate is 50 L/s, (ii) the elevation difference across the pump is...
-
Splitting hairs, if you shine a beam of colored light to a friend above in a high tower, will the color of light your friend receives be the same color you send? Explain.
-
The French group Club Mditerrane is an active service provider in the leisure and hospitality field with, in particular, its rich network of all-inclusive resort villages. The statements of income...
-
The Smetana Company has a commercial activity in the beauty products and cosmetics sector. Required Analyze the statement of cash flows prepared in Assignment 14.2 Smetana Company (1), in Chapter 14.
-
Multiple Choice Questions Raw materials and merchandise purchased can be included in (two possible alternative answers) (a) Cash (b) Expenses (c) Fixed assets (d) Current assets (e) None of these 2...
-
What is the ratio T f /T i for this process? A. 1/4 B. 1/2 C. 1 (no change) D. 2 E. 4 F. There is not enough information to decide. p (atm) 4 3- 2 1 0- 0 2 -V (m)
-
An aluminum ring is tight around a solid iron rod. If we wish to loosen the ring to remove it from the rod, we should A. Increase the temperature of the ring and rod. B. Decrease the temperature of...
-
Jn Figure 12.22, by comparing the slope of the graph during the time the liquid water is warming to the slope as steam is warming, we can say that A. The specific heat of water is larger than that of...
Study smarter with the SolutionInn App