Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

a docs.google.com/spreadsheets/d/1jlkTkl7Fo62xax2646zoUIM2YNYcz1sJ/edit#gid=1423838489 Update Book5 Copy .XLSX Share File Edit View Insert Format Data Tools Help Last edit was made 31 minutes ago by Zorawar Toor

image text in transcribed
a docs.google.com/spreadsheets/d/1jlkTkl7Fo62xax2646zoUIM2YNYcz1sJ/edit#gid=1423838489 Update Book5 Copy .XLSX Share File Edit View Insert Format Data Tools Help Last edit was made 31 minutes ago by Zorawar Toor 100% * $ % .0_.00 123 - Calibri 12 31 A1 fx A B C E F G H I J Actual Flexible budget Master budget Flexible Budget Variance F/U 31 32 Number of Mares 45 45 58 33 Number of Boarding Days 16250 16425 24820 (175) U 34 Sales 568,750.00 492,750.00 744,600.00 76,000 F 35 Variable Expenses 36 Feed 146,250.00 114,975.00 173,740.00 31,275 F 37 Veterinary Fees 97,500.00 65,700.00 99,280.00 31,800 F + 38 Blacksmith Fees 5,688.00 9,033.75 13,651.00 (3,346) U 39 Supplies 4,063.00 5,748.75 8,687.00 (1,686) U 40 Total Variable Expenses 253,500.00 195,457.50 $ 295,358.00 58,043 F 41 Contribution Margin 315,250.00 297,292.50 449,242.00 $ 17,958 F 42 Less: Fixed Expenses 43 Depreciation 40,000.00 40,000.00 40,000.00 44 Insurance 25,000.00 25,000.00 11,000.00 45 Utilities 17,000.00 17,000.00 14,000.00 46 Repairs and Maintenance 30,250.00 30,250.00 11,000.00 47 Labor 88,000.00 88,000.00 95,000.00 48 Advertisement 35,000.00 35,000.00 8,000.00 49 Entertainment 50,000.00 50,000.00 5,000.00 un U 50 Total Fixed Expenses 285,250.00 285,250.00 184,000.00 51 Net Income 30,000.00 12,042.50 265,242.00 $ 17,958 F 52 53 4 Written Analysis on FI FXIRI F Rudset Renort. + Sheet1 + 76,007 129 APR 19 city Oul T X P

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

Step: 3

blur-text-image

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

Analytical Corporate Valuation Fundamental Analysis, Asset Pricing, And Company Valuation

Authors: Pasquale De Luca

1st Edition

331993550X, 9783319935508

More Books

Students also viewed these Accounting questions

Question

describe and present a summary of data you have collected.

Answered: 1 week ago

Question

collect, organise and store quantitative data in an effective way;

Answered: 1 week ago