Prepare an annual operating budget for Troy Shoes based on this information. Show a gross profit and net income line and ignore any income tax effect.
Expected sales, 200 pair @ $200 average price
Cost of sales, 75% of sales
Internet fees, $52 per month
Shoe show entrance fees per year, $300
Mileage costs per year, $550
Advertising per month, $38
Depreciation of shelving per year $180
Owner withdrawals per month, $400

for formulas and calculations, refer to the image below -

In case you have any query, kindly ask in comments.
Prepare an annual operating budget for Troy Shoes based on this information. Show a gross profit...
Selling price per pair of shoes $40 cost per pair of shoes $25 Total annual fixed costs Salaries Advertising Other fixed expenses 100,000 40,000 100,000 i. Calculate the break even point and margin of safety in number of pairs of shoes sold ii Assume that 20,000 pairs of shoes were sold in a year Calculate the shops net income or loss (S marks i) If a sellimg commission of $2 per paar of shoe sold wes to be introduced, how...
Donut Information Based on the below data, create the profit model for Donuts to Go. Assume that each customer will buy one donut and one cup of coffee Sales estimate range from 200-5000 per week Time period Revenue: Cup of Coffee Revenue: Donut Donut ingredients per donunt) paper products: napkins, plates etc Insurance $4.00 $3.50 $0.60 per donut $5,550.00 month $200.00 Maintenance & Repairs to equipment month Marketing & Promotion: Advertising month Coffee per cup Coffee cups per cup Payroll:...
The controller of Dash Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budgetinformation: March April May Sales $129,000 $156,000 $206,000 Manufacturing costs 54,000 67,000 74,000 Selling and administrative expenses 37,000 42,000 45,000 Capital expenditures _ _ 49,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 65% are expected to be collected in the month following the sale and the...
eBook Show Me How Calculator Printem The controller of Dash Shoes Inc. Instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: March April May Sales $125,000 $158,000 $210,000 Manufacturing costs 53,000 68,000 76,000 Selling and administrative expenses 36,000 43,000 46,000 Capital expenditures 50,000 The company expects to sell about 15% of its merchandise for cash of sales on account, 60% are expected to be collected in the month...
I need a help with the solution for the Master Budget
Performance Report and Flexible Budget Performance Report in the
tables given, based on the Budget assumptions given in the same
attachment.
I need help with the formulas for excel.
Thank You!
Kelsey's Frozen Confectionaries Master Budget Performance Report For the month ended June 30 20,000 cases 50.00 per case 4 Volume S Sales Revenue MASTER 6 Percent sold on credit 90% percent of sales ACTUAL BUDGET VARIANCE VAR.% Volume...
Phoenix Company's 2017 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2017 Sales Cost of goods sold Direct materials Direct labor $3, 150, 000 $975, 000 225, 000 45, 000 315, 000 210,000 200, 000 Machinery repairs (variable cost) Depreciation-Plant equipment (straight line) Utilities ($60, 000 is variable) Plant management salaries Gross profit Selling expenses Packaging Shipping...
Founded in 2006 by Blake Mycoskie, TOMS Shoes was an American footwear company based in Santa Monica, California. Although TOMS Shoes was a for-profit business, its mission was more like that of a not-for-profit organization. The firm’s reason for existence was to donate to children in need one new pair of shoes for every pair of shoes sold. Blake Mycoskie referred to it as the company’s “One for One” business model. While vacationing in Argentina during 2006, Mycoskie befriended children...
Required: Prepare a master budget for the three-month period ending June 30. Include the following detailed schedules: 1. a. A sales budget, by month and in total. b. A schedule of expected cash collections, by month and in total. c. A merchandise purchases budget in units and in dollars. Show the budget by month and in total. d. A schedule of expected cash disbursements for merchandise purchases, by month and in total. 2. A cash budget. Show the budget by...
Cost Classification: The Lee’s have provided you with the following costs and relevant information that are assumed for year 20XY. A. Classify each of the costs (a. through j.) below under C. as a variable cost or a fixed cost. B. Explain the importance of distinguishing between variable and fixed costs. C. Prepare a budgeted income statement, assuming 600 units to be produced and sold, a per unit selling price of $85, an income tax rate of 28% and the...
INSTRUCTIONS:
Based on the information available below, complete the
Cash Budget, Income Statement, and Budgeted Balance Sheet
worksheet
4 A relatively new company, Get Laughy Taffy, Inc., has determined they need to engage in a budgeting 5 process as part of their new strategic plan. The Company has asked you to provide the following items 6 for the months of January, February, and March of 2020: A) a Purchases Budget; B) a Cash Budget; C) a 7 Budgeted Income Statement;...