FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Not sure if I did this correctly. x Income Tax B C D G o Corporate Finance Institute. All rights reserved. Operating Budget Budget FY

Not sure if I did this correctly.
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
x Income Tax B C D G o Corporate Finance Institute. All rights reserved. Operating Budget Budget FY 2021 Budget Budget Budget Budget Budget Budget Budget Budget Jan Feb Mar Apr May Jun July Aug Sep ACCOUNT NAME Volume Units Contracts Products 40.800 1.900 3,000 49 200 1.900 3,000 59,200 1,900 3,000 51.200 1,900 3.000 200,400 1.900 3,000 46,000 1.900 3,000 45,100 1.900 3,000 49,000 1,900 3,000 55.200 1.900 3.000 Price per Unit Indirect materials (50.15) Indirect labor (50.10) Other ($0.25) 6,120.0 400.0 0.0 7,380.0 400.0 0.0 8.880.0 3000 0.0 7,645.0 400.0 0.0 6,159.0 400.0 0.0 5.550.0 400.0 0.0 4,396.0 4,000,0 0.0 7,451.0 400.0 0.0 8.1000 400.0 0.0 Revenue Sales and other operating revenues Unearned revenues Interest revenues 46,400 3,650 20,000 46,400 3,650 20,000 46,400 3,650 20,000 46,400 3,650 20,000 46,400 3,650 20.000 46,400 3.650 20.000 46,400 3,650 20,000 46,400 3,650 20,000 46,400 3.650 20,000 70.050 70,050 Total Revenue 70,050 70.050 70.050 70,050 Less Variable Costs: Cost of goods sold Variable expense: Selling and administrative expense Notes payable Contribution margin Fixed expenses Payment processing fee Direct labor Frieght Certain aspects of marketing 0 2,000 5,072 35,000 25,000 50,000 400 45,000 500 3.900 0 2,000 5.072 35,000 25,000 50,000 400 45,000 500 3.900 0 2,000 5,072 35.000 25.000 50,000 400 45,000 500 0 2,000 5,072 35.000 25,000 50,000 400 45,000 500 3.900 0 2000 5.072 35.000 25,000 50,000 400 45,000 500 3.900 0 2,000 5,072 35,000 25.000 50,000 400 45,000 500 3.900 D 2,000 5,072 35,000 25,000 50,000 400 45,000 500 3,900 0 2000 5,072 35,000 25.000 50.000 400 45,000 500 3,900 0 2,000 5,072 35,000 25,000 50,000 400 45,000 500 3.900 3.900 Commissions Accounts Receivable (10%) Common stock Retained earnings 2,120 16,500 25,000 20,000 2.120 16,500 25.000 20,000 2,120 16,500 25,000 20,000 2.120 16,500 25,000 20.000 2.120 16.500 25.000 250.000 2.120 16.500 25,000 20,000 2,120 16,500 25,000 20.000 2,120 16,500 25,000 20,000 2,120 16,500 25,000 20,000 Total Vanable costs Contribution Margin 230,492 (160,442) 230.492 (160.442) 230,492 (160,442) 230,492 (160.442 460,492 390.442) 230,492 (160.442) Less Fixed Costs Group 1: Rent Wages 75,000 3,350 75,000 3.470 75.000 3,350 75,000 3.491 75 000 3350 75.000 3386 75,000 3,350 75,000 3.491 75,000 3.500 im Rudaot T + fx Income Tax actrecem served Operating Budget Budget FY 2021 Budget Budget Budget Budget Budget Bulget Budget Budget Budegt FY 2021 Budet Budget ACCOUNT NAME Jan Feb Mar Apr May jun July AVE Sep Oct New Dec 42 75.000 44 45 46 Less Fixed Costs Group 1: Rent Wages Insurance on building Management salaries and benefits unities 75.000 3350 20.000 377.000 75.000 3350 30.000 377.000 3,600 25,000 1470 10.000 377.000 4100 3.491 50.000 377,000 3900 75.000 3350 30,000 377,000 4056 75.000 20186 30.000 377,000 4000 75.000 2350 2000 377,000 1200 75.000 3.500 30.000 377.000 75.000 3491 30.000 377.000 2989 75.000 2350 30.000 177.000 4300 75,000 4000 30.000 377.000 75.000 3,491 30,000 377.000 5100 48 40 4000 4215 30 51 1800 3,000 Less Fixed Costs Group 2 Holiday vacation, pay Pre-paid insurance Advertising marketing Depreciation Payrollares 1.500 51 3,000 1.500 5.872 0 12,457 1500 5072 D 12.457 1000 12.500 5.072 0 12.607 5.072 0 12.700 3.000 1500 5.072 0 12.457 3.000 1500 5072 0 12.699 3000 1500 5,072 O 12.457 3.000 1.500 072 0 12.457 3.000 1500 6072 0 12,700 3.000 1500 5.1972 0 12.457 2000 1.500 5,072 D 13.467 3.000 1.500 5.022 0 12,700 55 56 17 58 19 60,000 4230 66.000 4620 60.000 45230 60,000 6230 60.000 46,230 50.000 4230 Less Fixed Costs Group 3: Office manager Supervisory Salaries Gross proft Budget repairs Business insurance 60.000 46210 1.000.000 15,000 30,000 60,000 46310 1.000.000 15.000 30,000 60.000 46.230 1000000 15.000 30.000 60,000 46.230 1.000.000 15.000 30.000 60,000 6230 1.000.000 15,000 30.000 60.000 46,230 1.000.000 15,000 30.000 15.000 30.000 15.000 30.000 15.000 30.000 15.000 30.000 15.000 30000 15.000 30.000 54 13.08 1662.00 662GO 16621 1663.655 ELEKT THAT Net Operating Marin 66 67 Depreciation & Amortisation Depreciation experte 2.000 2.000 2.000 2.000 2.000 2.000 2.000 2,000 2000 2,000 2.000 2000 70 71 12 73 9,000 9.000 1.000 1000 Other Expenses Office Supplies Central Supplies Regare and Mantence Travel Medical supplies 9.000 1,000 390) 900 11,231 9,000 1.500 00 900 11,231 9.000 1.000 3,3009 900 11,232 (1,3001 900 9.000 2.000 12.1001 900 11232 5.000 1,000 (1.100 900 11.232 9.000 1000 13.300 900 11,232 000 1000 2100 900 11,232 9,000 1,000 300 900 11,272 9,000 2,000 2100 900 10202 9.000 2.000 (10) 900 11.232 900 11,232 11232 75 76 TI 78 79 21 Pristina Open Interest Expenses Cover Page Operating Budget T... 2 NCAN TELVE Operating Budget 3 FY 2021 Budget Budget Budget Budget Budget Budget 4 5 Budget Budget Budget FY 2021 Budegt Budegt ACCOUNT NAME Business insurance Jan 30,000 Apr Feb 30,000 Mar 30.000 30.000 May 30,000 jun 30,000 July 30.000 Aug 30,000 Sep 30,000 Oct 30.000 Nov 30.000 Total Fixed Costs Net Operating Margin 1.662,609 1,663,209 1,663,069 1,662,893 1,662,665 1.662.87 Depreciation & Amortisation Depreciation expense 2,000 2,000 2000 2.000 2,000 2,000 2,000 2.000 2.000 2.000 2,000 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 BO BT 9.000 Other Expenses Office Supplies Central Supplies Repaire and Maintence Travel Medical supplies 9.000 1.000 (3.300) 900 11,231 9,000 1,500 (3,300) 900 11,231 9,000 1,000 (2.300) 900 11,232 9,000 1,000 3.300) 900 11,232 9.000 2.000 3.300) 900 11.232 9,000 1,000 3,300 900 51.232 9,000 1000 3.300) 900 11.232 9,000 1,000 13,300) 900 11,232 1,000 3.3001 900 11,232 9,000 1,000 63,3003 900 11,232 9,000 2,000 3.3001 900 11,232 21131 20.232 20,132 21,832 20,832 Depreciation and Other Expenses 20,831 Earnings before interest and taxes *** 500 Interest Expenses Intrest Payable Accrued interest Prepaid interest 500 0 2.000 500 0 2,000 500 0 2000 500 0 2,000 500 D 2.000 500 0 2.000 B3 500 0 2.000 500 0 2.000 500 0 2,000 500 O 2.000 2.000 65 56 2.500 2.500 2.500 2.500 2,500 2,500 Total Interest Expense Earning before tax 88 0 0 D D Income Tax 90 Wea Net Income 92 88989988 94 95 96 100 101 FY 2021 Budegt Budget Budget Budget Budegt Budget Budget Total Jan. Dec Actual Total Jan - Dec Variance Variance Actual vs Budget Actual vs Budget % July Sep Aug Oct Dec Nov 45.100 1,900 3,000 49,000 1,900 3,000 55,200 1,900 3,000 39,900 1.900 3,000 41,000 1,900 51,200 1,900 3,000 728,200 22,800 36,000 5,000,000 10,000,000 4,000,000 586 696 43759.6 11011.1 4,271,800 9.977,200 3,964,000 3,000 4.396.0 4,000.0 0.0 23.7 11.1 7.451,0 400.0 0.0 8,100,0 400.0 0.0 5,013,0 300.0 0.0 7,680.0 300.0 0.0 9,256,0 300.0 0.0 0.8 1.9 6.7 24.5 13.0 19.B 31.0 58 20 13.1 46,400 3.650 20,000 46,400 3,650 20,000 46,400 3,650 20,000 46,400 3,650 20,000 46,400 3,650 20,000 46,400 3,650 20,000 555,800 43.800 240,000 122,500,000 130,000,000 79,000,000 21900,7 296703.796 32816.7% 121,943,200 129,956,200 78.760,000 840,600 331,500,000 39336% 330,659,400 0 2,000 5,072 35,000 25,000 50,000 400 45,000 500 3.900 0 2,000 5,072 35,000 25,000 50,000 400 45,000 500 3,900 0 2,000 5,072 35,000 25,000 50,000 400 45,000 500 3,900 0 2.000 5,072 35,000 25,000 50,000 400 45,000 500 3.900 0 2,000 5,072 35,000 25,000 50,000 400 45,000 500 3,900 0 2,000 5,072 35,000 2,500 50,000 400 45,000 500 3,900 0 24,000 60,864 420,000 277.500 600,000 4,800 540,000 6,000 46,800 2.750,000 2.750,000 2,750,000 2,750,000 2,750,000 2,750,000 2,750,000 2.750,000 2,750,000 2,750,000 na 11358.3% 4418.3% 554.8% 891.0 358 3 57191,796 409 396 45733.3% 5776.17 2,750,000 2.726,000 2,689,136 2,330,000 2,472,500 2,150,000 2,745.200 2.210,000 2,744.000 2.703.200 2.120 2,120 16,500 25,000 20,000 2.120 16,500 25,000 20,000 2,120 16,500 25,000 20,000 2,120 16,500 25,000 20,000 2,120 16,500 25,000 20,000 16,500 25,000 20,000 25.440 198,000 300,000 470,000 2.750,000 2,750,000 2,750,000 2,750,000 10709.7 1288.9% 816.796 485.1% 2.724,560 2,552,000 2.450,000 2.280,000 2,973,404 (2.132,804) 38,500,000 293,000,000 1195 - 13838% 35,526,596 295,192,804 75,000 3,350 75,000 3.500 75.000 3,491 75,000 3,350 75,000 4,000 75,000 3,491 900,000 41.579 12,500,000 12,500,000 1288.9% 29963.3% 11,600,000 12.458,421 iget Budget Budget Budegt Budegt Budget Variance Variance Actual vs Budget Actual vs Budget ly Aug Sep Oct Nov Dec Budget Total Jan. Dec 2,973,404 (2,132,804) Actual Total Jan-Dec 38,500,000 293,000,000 % 1195% -13838% 35,526,596 295,132,804 5.000 3,350 0,000 7,000 3,200 75,000 3,500 30,000 377,000 4,100 75,000 3,491 30,000 377,000 3.989 75,000 3,350 30,000 377,000 4,300 75,000 4,000 30,000 377,000 4,215 75,000 3,491 30,000 377,000 5,100 900,000 41,579 360,000 4,524,000 48,560 12,500,000 12,500,000 12,500,000 12,500,000 12,500,000 1288.9% 29963 396 3372.2% 176.3% 25641.4% 11,600,000 12.458,421 12.140,000 7,976,000 12,451,440 3,000 1,500 5,072 0 2,457 3,000 1,500 5,072 0 12,457 3,000 1,500 5,072 0 12,700 3,000 1,500 5,072 0 12,457 3,000 1,500 5.072 0 13,467 3,000 1,500 5,072 0 12,700 36,000 18,000 60,864 0 151,705 12,500,000 12 500,000 12,500,000 12,500,000 12,500,000 34622.2% 69344 496 20437.6% na 8139.7% 12,464,000 12.482,000 12,439,136 12,500,000 12 348,295 0,000 6,230 60,000 46,230 60,000 46,230 60,000 46,230 60,000 46,230 60,000 46,230 720,000 554,760 6,000,000 180,000 360,000 5,000 0,000 15,000 30,000 15,000 30,000 15,000 30,000 12,500,000 12,500,000 12,500,000 12,500,000 11,945,240 6,500,000 12,320,000 12.140,000 15,000 30,000 2153,2% 108 3% 6844.4% 3372.2% 15,000 30,000 13,955,468 (16,088,272) 175,000,000 118,000,000 11544 -833% 161,764,532 133,368,272 2,000 2,000 2,000 2,000 2,000 2,000 24,000 0 25,000,000 25,000,000 104066.7% na 24,976,000 25,000,000 9,000 1,000 8.300) 900 1,232 9,000 1,000 (3,300) 900 11,232 9,000 1.000 (3.300) 900 11,232 9,000 1,000 (3.300) 900 11,232 9,000 2,000 (3,300) 900 11,232 9,000 2,000 (3,300) 900 11,232 108,000 15,500 (39.600) 10,800 134,782 5,500,000 5.500.000 5,500,000 5.500,000 5.500.000 4992.6% 35383.9% -13988.99 50825.9% 3980.79 5.392,000 5,484,500 5,539,600 5.489,200 5,365,218 253,482 (16,341,754) 77,500,000 40,500,000 304744 348% 77,246 518 56,121,754 FY 2021 Budegt Budget Budegt Budget Budget Total Jan-Dec 360,000 Actual Total Jan - Dec 12,500,000 Variance Variance Actual vs Budget Actual vs Budget % 3372.2% 12,140,000 Oct Sep 30,000 Nov 30,000 Dec 30,000 30,000 13,955,468 175,000,000 (16,088,272) 118,000,000 1154% -833% 161.764 532 133,368,272 104066.7% 80 2,000 2,000 2,000 2,000 24,000 0 25,000,000 25,000,000 24,976,000 25,000,000 na 9,000 1,000 (3,300) 9,000 1,000 (3,300) 900 11,232 9,000 2,000 (3,300) 9,000 2,000 (3,300) 900 11,232 0) 108,000 15,500 (39,600) 10,800 134,782 4992.6% 35383.9% -13988.9% 50825.99 3980.7% 5,500,000 5,500,000 5,500,000 5,500,000 5,500,000 5,392,000 5,484,500 5,539,600 5,489,200 5,365,218 900 900 32 11,232 11,232 253,482 (16,341.754) 77,500,000 40,500,000 30474% -348% 77 246 518 56,121,754 00 500 500 0 2,000 500 0 2,000 500 0 2,000 6,000 0 24,000 -100.0% na -100.0% 0 (6,000) 0 (24,000) 0 00 2,000 30,000 (16,371,754) -1004 -347% 30,000) 56,151,754 40,500,000 nia 2.750,000 0 2,750,000 0 0 0 0 -331% 53,401,754 (16,371,754) 37,750,000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Horngrens Financial & Managerial Accounting, The Managerial Chapters

Horngrens Financial & Managerial Accounting, The Managerial Chapters

Authors: Tracie Miller Nobles, Brenda Mattison

7th Edition

0136503616, 9780136503613

More Books

Students also viewed these Accounting questions

Question

★★★★★
There are two stocks in the market, Stock A and Stock B. The price of Stock A today is $75. The price of Stock A next year will be $64 if the economy is in a recession, $87 if the economy is normal,...

Answered: 1 week ago

Question

★★★★★
Describe how you will remember the forward- and reverse-bias states of the p n junction diode. That is, how will you remember which potential (positive or negative) is applied to which terminal?

Answered: 1 week ago

Question

★★★★★
=+e) A dogs intelligence can be judged roughly by how many times a new command must be repeated until it is learned. A researcher trained several dogs of each of 4 different breeds, teaching them 3...

Answered: 1 week ago

Question

★★★★★
Complete the chart below, indicating the Calvet Trusts entity accounting income for each of the alternatives. For this purpose, use the following information. Interest income, taxable Interest...

Answered: 1 week ago

Question

★★★★★
29) The balances of select accounts of Sasha Company as of December 31, 2018 are given below. Debit Credit Building $130,000 Cash 9000 Office Supplies 800 Furniture 6000 Prepaid Insurance 450...

Answered: 1 week ago

Question

★★★★★
Economics: Microeconomics - Spending and Saving The budget constraint is the lower limit on a consumer's spending is the maximum utility an individual can achieve U has to do with a consumer's...

Answered: 1 week ago

Question

★★★★★
According to Joint Publication 3-24, Counterinsurgency, why should precision engagement by airpower "be designed to employ [host nation] airpower resources to the greatest extent possible

Answered: 1 week ago

Question

★★★★★
The tension between my mother and me rapidly increased once I moved home from college as she gave me little to no privacy. I was mature, had a full-time job, and wasn't the same as before I left four...

Answered: 1 week ago

Question

★★★★★
The table below presents the tax revenue and spending for the government over five years. a. Under the "Budget Amount" column calculate the annual budget outcome. Instructions: Enter your answer as a...

Answered: 1 week ago

Question

★★★★★
According to valor how can the framework of virtue ethics the ride inside in the hell robot human interactions condition the social and emotional character of humans especially patients And caregivers

Answered: 1 week ago

Question

★★★★★
Extract B (lines 20-21) states that 'all vehicle owners should be forced to pay the full costs of their driving. This would incentivise people to consider using public transport, cycling or walking....

Answered: 1 week ago

Question

★★★★★
Think about a group to which you belong. It may be a work group or a social group such as a fraternity or an interest club. Describe some common rites and rituals in your group. What do these rites...

Answered: 1 week ago

Question

★★★★★
Based on this discussion, does this group seem to have a single leader, or do different members provide leadership to the group?

Answered: 1 week ago

Question

★★★★★
Although Twelve Angry Men was produced many years ago, it remains an excellent fi lm about group dynamics in a decision-making group, in this case a jury.

Answered: 1 week ago

Previous Question Next Question