Sales projections are as follows: 4th 1st 25,000 24,000 V Unit Sales Cost of materials...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Sales projections are as follows: 4th 1st 25,000 24,000 V ✓ Unit Sales Cost of materials Labor mix hourly cost 23 ● $.14 $18 23 $.15 $18 2nd 30,000 24 $.15 1 $18.50 3rd 34,000 24 7 1 $18.50 $.16 Variable $3.90 $4.00 $4.00 $4.05 Selling Expense 4th 45,000 25 $.17 $19 1st 27,000 25 $.17 $19 7 Percent of cash sales collected in the period 40% • Percent of credit sales collected in period of sale 40% Percent of credit sales collected after quarter of sale 20% 2nd 29,000 25 • Percentage of purchases paid for in the period of purchase 65% • Percentage of purchase paid for in the subsequent quarter 35% • Direct labor hours required to produce one unit .25 hours • Variable Manufacturing OH rate per direct labor hour is $4.25 Minimum required cash balance $25.000 $.17 $4.10 $4.10 $4.10 $19.5 • Desired ending inventory percentage of next quarters production needs 10% • Amount of materials needed for one unit to be produced is 8 pounds • Desired ending inventory percentage of next quarters materials needs 15% • Quarterly interest rate on loans outstanding charged from the beginning of the quarter 3% V Tax rate 30% Fixed Factory overhead quarterly costs is made up of $14,000 Depreciation expense, $19,000 security expense, $61,000 indirect labor expense. Fixed SG&A quarterly expense is made up of $55,000 advertising expense, $95,000 executive salaries, $10,000 insurance expense, $14,000 Property tax expense, $10,000 depreciation expense. • Beginning balances on the balance sheet are as follows: o Cash 50,000, Accounts Receivable (you figure out), Raw materials (you figure out), finished goods (you figure out), Land $80,000, Buildings and Equipment $700,000, Accumulated depreciation $292,000, Accounts payable (you figure out), Common Stock $200,000, no loans outstanding, Retained earnings (you figure out....hint, back into this) Additional budget information: Capital Cash 1st $80,000 $10,000 2nd $100,000 $10,000, 3rd $60,000 $10,000 4th $20,000 $10,000 V Dividends paid out Using excel, Prepare all budgets necessary in order to prepare proforma financials. Sales projections are as follows: 4th 1st 25,000 24,000 V ✓ Unit Sales Cost of materials Labor mix hourly cost 23 ● $.14 $18 23 $.15 $18 2nd 30,000 24 $.15 1 $18.50 3rd 34,000 24 7 1 $18.50 $.16 Variable $3.90 $4.00 $4.00 $4.05 Selling Expense 4th 45,000 25 $.17 $19 1st 27,000 25 $.17 $19 7 Percent of cash sales collected in the period 40% • Percent of credit sales collected in period of sale 40% Percent of credit sales collected after quarter of sale 20% 2nd 29,000 25 • Percentage of purchases paid for in the period of purchase 65% • Percentage of purchase paid for in the subsequent quarter 35% • Direct labor hours required to produce one unit .25 hours • Variable Manufacturing OH rate per direct labor hour is $4.25 Minimum required cash balance $25.000 $.17 $4.10 $4.10 $4.10 $19.5 • Desired ending inventory percentage of next quarters production needs 10% • Amount of materials needed for one unit to be produced is 8 pounds • Desired ending inventory percentage of next quarters materials needs 15% • Quarterly interest rate on loans outstanding charged from the beginning of the quarter 3% V Tax rate 30% Fixed Factory overhead quarterly costs is made up of $14,000 Depreciation expense, $19,000 security expense, $61,000 indirect labor expense. Fixed SG&A quarterly expense is made up of $55,000 advertising expense, $95,000 executive salaries, $10,000 insurance expense, $14,000 Property tax expense, $10,000 depreciation expense. • Beginning balances on the balance sheet are as follows: o Cash 50,000, Accounts Receivable (you figure out), Raw materials (you figure out), finished goods (you figure out), Land $80,000, Buildings and Equipment $700,000, Accumulated depreciation $292,000, Accounts payable (you figure out), Common Stock $200,000, no loans outstanding, Retained earnings (you figure out....hint, back into this) Additional budget information: Capital Cash 1st $80,000 $10,000 2nd $100,000 $10,000, 3rd $60,000 $10,000 4th $20,000 $10,000 V Dividends paid out Using excel, Prepare all budgets necessary in order to prepare proforma financials.
Expert Answer:
Answer rating: 100% (QA)
Here are the budgets necessary to prepare the pro forma financials 1 Sales Budget Quarterly unit sales projections 1st quarter 27000 units 2nd quarter ... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
The Excel worksheet form that appears below is to be used to recreate the Review Problem related to Mynor Corporation. Download the workbook containing this form from Connect, where you will also...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-6. On December 12, Irene purchased the building where her store is located. She paid...
-
+9.33 x 10 C +91 Find the net force on 92. 0.180 m +4.22 x 10 C +92 0.230 m- -8.42 x 10 C 93 F = force exerted on q2 by 91 F3 = force exerted on 92 by 93 F = 10.9 N F3 = 6.04 N Remember: Forces...
-
GlaxoSmithKline, a British company, is one of the largest pharmaceutical firms in the world. Refer to GlaxoSmithKline's 2008 statement of cash flows and answer the following questions. 1....
-
A typical credit card may quote an APR of 18 percent. On closer inspection, you will find that the rate is actually 1.5 percent per month. What annual interest rate are you really paying on such a...
-
Repeat the calculations of Example 6.3, but for \(80 \mathrm{~mol} \%\) of the liquid distilled. Data From Example 6.3:- Suppose the liquid of Example 6.1 [50 mol% n-heptane (A), 50 mol% n-octane...
-
BigScreen Corporation manufactures and sells 50-inch television sets and uses standard costing. Actual data relating to January, February, and March of 2009 are: The selling price per unit is $2,500....
-
Suppose that both players discount future payoffs with the same discount factor ? < 1. Suppose that both players play the "Cooperative Strategy;" namely, they play C in every period, no matter what...
-
The following adjusted revenue and expense accounts appeared in the accounting records of Pashi, Inc., an accrual basis taxpayer, for the year ended December 31, Year 2. Revenues Net sales $3,000,000...
-
You're given this Initial Value Problem: y' = 1/(y-1) + (y-3)^1/3 + tan(t), y(pi) = 2. Find the largest open rectangle on the ty-plane.
-
What game was cancelled as a result of the 1967 San Jose State revolt? How much did it cost the school?
-
Ontario's Ministry of Transportation has advertised an A B contract for the repaving of a bridge on a busy 4-lane divided highway. The works must be completed with the bridge partially open, 2 lanes...
-
As a global generic strategy, Adaptation is most likely when?
-
What influence does media portrayal of undocumented immigrants exert on the shaping of perceptions regarding the Latino community?
-
What is the most common explanation for teenagers becoming pregnant in Canada?
-
X Company estimates that 2% of its sales on account for the year ended December 31, 200A will be uncollectible. If the total sales is $4,500,000 and 20% is cash sales, the adjusting entry for the...
-
Briefly discuss the implications of the financial statement presentation project for the reporting of stockholders equity.
-
Mike sells his home to Jane on April 2, 2012. Jane pays the property taxes covering the full calendar year in October, which amount to $2,500. How much may Mike and Jane each deduct for property...
-
Bea Jones (age 32) moved from Texas to Florida in December 2011. She lives at 654 Ocean Way, Gulfport, FL 33707. Bea's Social Security number is 466-78-7359 and she is single. Her earnings and income...
-
Tom has a successful business with $100,000 of income in 2012. He purchases one new asset in 2012, a new machine which is 7-year MACRS property and costs $25,000. If you are Tom's tax advisor, how...
-
The following table shows the interest rates on the fixed and floating borrowing choices available to three firms. Firms A and B want to be exposed to a floating interest rate while Firm C would...
-
Futures contracts are standardized contracts for the delivery of a specified quantity of a commodity or financial instrument on a prearranged future date, at an agreed- upon price. They are a bet on...
-
Derivatives transfer risk from one person or firm to another. They can be used in any combination to unbundle risks and resell them.
Study smarter with the SolutionInn App