Assume actual cash receipts and disbursements will follow the pattern below: (Note: Receivables and Payables of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Assume actual cash receipts and disbursements will follow the pattern below: (Note: Receivables and Payables of 12/31/x1 will have a cash impact in 20x2.) 1. 21.00% of sales for the year are made in November and December. Since our customers have 60 day terms those funds will be collected be collected in January and February. 2. 81.00% of material purchases will be paid during the year, the remaining portion will be paid in Januay or February. 3. All other manufacturing and operating costs are paid for when incurred. 4. The budgeted depreciation expense is equal to 0.6% of the fixed manufacturing, selling and administrative expenses. 5. Minimum Cash Balance needed for 20x2, $150,000. I See The Light Projected Cash Budget For the Year Ending December 31, 20x2 Beginning Cash Balance Cash Inflows: Sales Collections: Account Receivable (Sales last year not collected) Sales made and collected in 20x2 Cash Available Cash Outflows: Purchases Accounts Payable (Purchases last year) Material purchases made and paid for in 20x2 Other Manufacturing Costs Direct Labor Total Manufacturing Overhead Selling and Administrative Less: Depreciation Total Cash Outflows Budgeted Cash Balance before financing Needed Minimum Balance Amount to be borrowed (if any) Budgeted Cash Balance Round dollars to two places, $##.## {10.02} {10.03} {10.04} {10.05} {10.06} {10.07} {10.08} {10.09} {10.10} 9 Variable Cost of making one unit next year - used to calculate the Ending Inventory of Finished Goods Material cost per unit Labor Cost Per Lamp Variable Factory overhead per unit Total variable manufacturing cost of one unit 20x2 Cost Rounded to 7 Decimal Places {11.01} 10 Budgeted Operating Income Using Variable (Direct) Costing Sales Variable Cost of Goods Sold Assume FIFO (First-In, First-Out) - Beginning Inventory, Finished Goods (Variable Costing) Production Costs: Materials: Figurines: Electrical Parts Lamp Shades: Labor: Variable Overhead: 20x2 Cost Rounded to 2 Decimal Places {11.02} Total Variable Production Costs {11.03} Cost of Goods Available For Sale Less: Ending Inventory, Finished Goods (Variable Costing) {11.04} Variable Cost of Goods Sold Variable Selling (Round to two places, $##.##) {11.05} Variable Administrative (Round to two places, $##.##) {11.06} Total Variable Costs |{11.07} Contribution Margin Fixed Costs: Fixed Manufacturing Overhead Fixed Selling Fixed Administrative Total Fixed Operating Income, Variable Costing Operating Income, Absorption Operating Income, Variable Costing Excess (Absorption Costing Operating Income - Variable Costing Operating Income) Budgeted Fixed Overhead Budgeted Number of Units to be Produced Budgeted Fixed Cost Per Unit (Round to 7 decimals #.####***) {11.08} {11.09} {11.10} |{11.11} Fixed Manufacturing Overhead in the Ending Inventory {11.12} Fixed Manufacturing Overhead in the Beginning Inventory {11.13} Increase (Fixed Manufacturing Overhead in the Ending Inventory-Fixed Manufacturing Overhead in the Beginning Inventory) |{11.14} Assume actual cash receipts and disbursements will follow the pattern below: (Note: Receivables and Payables of 12/31/x1 will have a cash impact in 20x2.) 1. 21.00% of sales for the year are made in November and December. Since our customers have 60 day terms those funds will be collected be collected in January and February. 2. 81.00% of material purchases will be paid during the year, the remaining portion will be paid in Januay or February. 3. All other manufacturing and operating costs are paid for when incurred. 4. The budgeted depreciation expense is equal to 0.6% of the fixed manufacturing, selling and administrative expenses. 5. Minimum Cash Balance needed for 20x2, $150,000. I See The Light Projected Cash Budget For the Year Ending December 31, 20x2 Beginning Cash Balance Cash Inflows: Sales Collections: Account Receivable (Sales last year not collected) Sales made and collected in 20x2 Cash Available Cash Outflows: Purchases Accounts Payable (Purchases last year) Material purchases made and paid for in 20x2 Other Manufacturing Costs Direct Labor Total Manufacturing Overhead Selling and Administrative Less: Depreciation Total Cash Outflows Budgeted Cash Balance before financing Needed Minimum Balance Amount to be borrowed (if any) Budgeted Cash Balance Round dollars to two places, $##.## {10.02} {10.03} {10.04} {10.05} {10.06} {10.07} {10.08} {10.09} {10.10} 9 Variable Cost of making one unit next year - used to calculate the Ending Inventory of Finished Goods Material cost per unit Labor Cost Per Lamp Variable Factory overhead per unit Total variable manufacturing cost of one unit 20x2 Cost Rounded to 7 Decimal Places {11.01} 10 Budgeted Operating Income Using Variable (Direct) Costing Sales Variable Cost of Goods Sold Assume FIFO (First-In, First-Out) - Beginning Inventory, Finished Goods (Variable Costing) Production Costs: Materials: Figurines: Electrical Parts Lamp Shades: Labor: Variable Overhead: 20x2 Cost Rounded to 2 Decimal Places {11.02} Total Variable Production Costs {11.03} Cost of Goods Available For Sale Less: Ending Inventory, Finished Goods (Variable Costing) {11.04} Variable Cost of Goods Sold Variable Selling (Round to two places, $##.##) {11.05} Variable Administrative (Round to two places, $##.##) {11.06} Total Variable Costs |{11.07} Contribution Margin Fixed Costs: Fixed Manufacturing Overhead Fixed Selling Fixed Administrative Total Fixed Operating Income, Variable Costing Operating Income, Absorption Operating Income, Variable Costing Excess (Absorption Costing Operating Income - Variable Costing Operating Income) Budgeted Fixed Overhead Budgeted Number of Units to be Produced Budgeted Fixed Cost Per Unit (Round to 7 decimals #.####***) {11.08} {11.09} {11.10} |{11.11} Fixed Manufacturing Overhead in the Ending Inventory {11.12} Fixed Manufacturing Overhead in the Beginning Inventory {11.13} Increase (Fixed Manufacturing Overhead in the Ending Inventory-Fixed Manufacturing Overhead in the Beginning Inventory) |{11.14}
Expert Answer:
Related Book For
Advanced Accounting
ISBN: 978-1934319307
2nd edition
Authors: Susan S. Hamlen, Ronald J. Huefner, James A. Largay III
Posted Date:
Students also viewed these accounting questions
-
T 2 Stoner Machinery Options 3 Expiration Date Strike Price Call Price Put Price 4 1/15/2022 $145 $8.62 $1.89 5 1/15/2022 $155 $1.98 $6.67 6 3/15/2022 $145 $10.57 $3.25 7 3/15/2022 $155 $2.69 $9.25 8...
-
Calculate the amount of money to be included on the CD for the following scenario: Purchase price is $205,000. Loan amount is $190,000. The per diem interest on buyer's loan is $23.61. The lender is...
-
Corporate Collapses and Scandals is one of the fraud cases that have been world widely reported. Most of the fraud cases especially those committed in the accounting fraternity are attributable to...
-
Blackmon Company provides locator services to the city transportation departments. Blackmons service involves installing a dedicated hardware transmitter in each city bus. This transmitter provides...
-
As of November 3, 2013, Krispy Kreme Doughnuts had $ 530,000 of Notes Receivable due within one year, $ 28,650,000 of Accounts Receivable, and $ 600,000 in its Allowance for Doubtful Accounts (assume...
-
A track star runs two races on a certain day. The probability that he wins the first race is 0.7, the probability that he wins the second race is 0.6, and the probability that he wins both races...
-
Depreciation adjusting entries do not need to be posted. (True/False)
-
As the media landscape continues to change, and advertisers shift more and more of their monies into new media, there are those who predict that some traditional media like TV and newspapers may not...
-
Solano Company has sales of $700,000, cost of goods sold of $470,000, other operating expenses of $50,000, average invested assets of $2,100,000, and a hurdle rate of 9 percent. Required: 1....
-
A molecule that blocks the activity of carbonic anhydrase would immediately decrease the amount of carbon dioxide dissolved in the plasma. cause an increase in blood pH. interfere with oxygen binding...
-
Gloopy Ketchup Company makes and sells bottles of tomato ketchup. Annual demand is 24,000bottles. For each bottle of ketchup they need six pounds of tomatoes, which they normallypurchase for $0.30...
-
examine the internal environment of Blue Nile Inc., by reviewing the current situation in terms of current performance and strategic posture; as well as the corporate governance by understanding the...
-
Provide description of course work as a nuclear engineer / chemical engineer? You are in downtown Columbia and a farm truck with an unmarked tank trailer stops (the trailer is carrying anhydrous...
-
What roles do hormones play in regulating circadian rhythms, and how might disruptions in these rhythms affect overall health, behavior, and metabolism ?
-
ces AirQual Test Corporation provides on-site air quality testing services. The company has provided the following cost formulas and actual results for the month of February: Revenue Fixed Component...
-
Blast it! said David Wilson, president of Teledex Company. Weve just lost the bid on the Koopers job by $3,000. It seems were either too high to get the job or too low to make any money on half the...
-
If someone's Z-score for a variable was 0.67. Their score is a significant extreme score. Their score is not significant. O Their score is slightly above average. O Their score is an outlier.
-
Antonio Rossi set up a part-time business on 1 November 2004 buying and selling second-hand sports cars. On 1 November 2004 he commenced business with $66,000 which he immediately used to purchase...
-
Why is it necessary for financial reporting to be subject to (a) mandatory control and (b) statutory control?
-
How is it possible to make shareholders aware of the significance of the exercise of judgement by directors which can turn profits of 6m into losses of 2m?
Study smarter with the SolutionInn App