Donuts to go :
Basic detail compiled on the base of information available :
Donuts to Go | |
Revenue : Cup of coffee | 4.00 |
Revenue : Donut | 3.50 |
Variable Cost | |
Donut Ingredient | 0.60 |
Coffee | 0.25 |
Coffee Cup | 0.10 |
Fixed Overhead | |
Insurance | 200.00 |
Payroll | 3,500.00 |
Donut Coffee equipment rent | 500.00 |
Professional fees - Accounting | 50.00 |
Professional fees - legal | 25.00 |
Rent | 1,000.00 |
Supplies: Office | 25.00 |
Utilities | 200.00 |
Marketing & Promotion | 50.00 |
Total Fixed Overhead | 5,350.00 |
Donuts to go Model for different quantities of Sales :
Donuts to Go | ||||||||||||
Sales Units | ||||||||||||
Quantities | Per Unit | - | 500 | 1,000 | 1,500 | 2,000 | 2,500 | 3,000 | 3,500 | 4,000 | 4,500 | 5,000 |
Coffee | 4.00 | - | 2,000 | 4,000 | 6,000 | 8,000 | 10,000 | 12,000 | 14,000 | 16,000 | 18,000 | 20,000 |
Donut | 3.50 | - | 1,750 | 3,500 | 5,250 | 7,000 | 8,750 | 10,500 | 12,250 | 14,000 | 15,750 | 17,500 |
Total Revenue | 7.50 | - | 3,750 | 7,500 | 11,250 | 15,000 | 18,750 | 22,500 | 26,250 | 30,000 | 33,750 | 37,500 |
Total Fixed Expenses | 5,350.00 | 5,350 | 5,350 | 5,350 | 5,350 | 5,350 | 5,350 | 5,350 | 5,350 | 5,350 | 5,350 | 5,350 |
Coffee Variable Expenses | 0.35 | - | 175 | 350 | 525 | 700 | 875 | 1,050 | 1,225 | 1,400 | 1,575 | 1,750 |
Donut Variable Expenses | 0.6 | - | 300 | 600 | 900 | 1,200 | 1,500 | 1,800 | 2,100 | 2,400 | 2,700 | 3,000 |
Total Variable Expenses | 0.95 | - | 475 | 950 | 1,425 | 1,900 | 2,375 | 2,850 | 3,325 | 3,800 | 4,275 | 4,750 |
Total Expenses | 5,350 | 5,825 | 5,825 | 5,825 | 5,825 | 5,825 | 5,825 | 5,825 | 5,825 | 5,825 | 5,825 | |
Profit on Donut & Coffe | (5,350) | (2,075) | 1,675 | 5,425 | 9,175 | 12,925 | 16,675 | 20,425 | 24,175 | 27,925 | 31,675 |
Basic detail compiled on the base of information available :
Muffins to Go | |
Revenue : Cup of coffee | 4.00 |
Revenue : Muffin | 5.50 |
Total Revenue | 9.50 |
Variable Cost | |
Muffin Ingredient | 1.20 |
Coffee | 0.25 |
Coffee Cup | 0.10 |
Total Variable Cost | 1.55 |
Fixed Overhead | |
Insurance | 500.00 |
Payroll | 3,500.00 |
Muffin Coffee equipment rent | 2,500.00 |
Professional fees - Accounting | 50.00 |
Professional fees - legal | 25.00 |
Rent | 2,000.00 |
Supplies: Office | 25.00 |
Utilities | 500.00 |
Marketing & Promotion | 250.00 |
Total Fixed Overhead | 8,600.00 |
Muffins to go Model for different quantities of Sales :
Muffins to Go | ||||||||||||
Sales Units | ||||||||||||
Quantities | Per Unit | - | 500 | 1,000 | 1,500 | 2,000 | 2,500 | 3,000 | 3,500 | 4,000 | 4,500 | 5,000 |
Coffee | 4.00 | - | 2,000 | 4,000 | 6,000 | 8,000 | 10,000 | 12,000 | 14,000 | 16,000 | 18,000 | 20,000 |
Muffins | 5.50 | - | 1,750 | 3,500 | 5,250 | 7,000 | 8,750 | 10,500 | 12,250 | 14,000 | 15,750 | 17,500 |
Total Revenue | 9.50 | - | 3,750 | 7,500 | 11,250 | 15,000 | 18,750 | 22,500 | 26,250 | 30,000 | 33,750 | 37,500 |
Total Fixed Expenses | 8,600.00 | 8,600 | 8,600 | 8,600 | 8,600 | 8,600 | 8,600 | 8,600 | 8,600 | 8,600 | 8,600 | 8,600 |
Coffee Variable Expenses | 0.35 | - | 175 | 350 | 525 | 700 | 875 | 1,050 | 1,225 | 1,400 | 1,575 | 1,750 |
Muffin Variable Expenses | 1.2 | - | 300 | 600 | 900 | 1,200 | 1,500 | 1,800 | 2,100 | 2,400 | 2,700 | 3,000 |
Total Variable Expenses | 1.55 | - | 475 | 950 | 1,425 | 1,900 | 2,375 | 2,850 | 3,325 | 3,800 | 4,275 | 4,750 |
Total Expenses | 8,600 | 9,075 | 9,075 | 9,075 | 9,075 | 9,075 | 9,075 | 9,075 | 9,075 | 9,075 | 9,075 | |
Profit on Muffin & Coffee | (8,600) | (5,325) | (1,575) | 2,175 | 5,925 | 9,675 | 13,425 | 17,175 | 20,925 | 24,675 | 28,425 |
Note : The previous R&D cost incurred is sunk cost hence not considerable.
Donut Information Based on the below data, create the profit model for Donuts to Go. Assume...
We will use the following information to create the profit model. Based on the data in the tables below, create the profit model for Donuts to Go and Muffins to Go. Profit = Total revenue X num. of units-Variable Expenses X num. of units-Fixed Expenses (what are the values for Total Revenue, Variable Expenses and Fixed Expenses?) Assume that each customer will buy one donut(or muffin) and one cup of coffee Come to class with both Profit Models written on...
Create a Statement of Cash Flow. All beginning balances will be Zero. All the professor gave us is this Trail Balance and said to create a Statement of Cash Flow with all beginning balances being zero. Credit Adjusted Trial Balance December 31, 2019 PR 105 107 110 Debit $24.485.00 SS 00 $11.750.00 Petty Cash T S1000100 $ 500.00 Prepaid Insurance Computer Equipment Accumulated Depreciation - Compu $21.00 CR An d Depreciation Cell Phone $2 260.00 $2.066.00 $112.00 $2,025.00 $675.00 $10,098.00...
Please complete the T-accounts, bank reconciliation(if anything needs to be added), income statement, ststement of retained earnings, balance sheeet, cash flow, closing entries, and post closing trial balance. Journal T-accounts (not completed) Unadjusted Trial Balance (completed) Adjustments Adjusted Trial Balance Income Statement Statement of Retained Earnings Balance Sheet Cash Flow Closing Entries Post Closing Trial Balance Debit Credit Account Names Started Corporation with $10,000.00 in exchange 10,000 shares common stock cash common stock $10,000.00 $10,000.00 2 Purchased a Computer for...
Here is the adjusted trial balance. Based on these figures, what should the balance sheet look like? Vehicle Inc. Adjusted Trial Balance 6/30/2017 Account Name DR.CR. Cash 500.00 Checking 5,600.00 Savings 7,800.00 Accounts Receivable 90,000.00 Warranty Receivables 500.00 New Motorcycle Inventory 499,600.00 New ATV Inventory 293,500.00 New Scooter Inventory 300.00 New Power Equipment Inventory 19,300.00 New Other Products Inventory 7,900.00 Used Motorcycle, ATV, Scooter I 69,900.00 Sublet Repairs-RO's in Progress 5,100.00 Parts Inventory 24,500.00 Accessories Inventory 136,700.00 Service Machinery &...
NEED HELP (confirm accuracy) ON NUMBERS 1, 6, 8 Thank you! Sam's Singles Service, Inc.- Practice Set Samantha has a knack for setting up friends and helping them with relationships. Last month she opened s Singles Service to provide dating consultations and to host events where like-minded singles could meet. You've taken over as Sam's new bookkeeper and are presented with the following chart of accounts and post-closing trial balance for January 31, 201x. Chart of Accounts Sam's Singles Service,...
calculate the net loss or net profit based on the information for the year. OME N Atte Sec . SCHEDULE C Profit or Loss From Business (Form 1040 or (Sole Proprietorship) 1040-SR) Go to www.lrs.gow Schedule for instructions and the latest information Department of the Treasury *Attach to Form 1040, 1040-SR, 1040-NR, or 1041; partnerships generally must file Form 1065. Intemal Revenue Service Income 1 Gross recebe orales. Incons for line 1 and check the box this come was reported...
Required information Comprehensive Problem 1 [The following information applies to the questions displayed below.] On December 1, Year 1, John and Patty Driver formed a corporation called Susquehanna Equipment Rentals. The new corporation was able to begin operations immediately by purchasing the assets and taking over the location of Rent-It, an equipment rental company that was going out of business. The newly formed company uses the following accounts. Cash Capital Stock Accounts Receivable Retained Earnings Prepaid Rent Dividends Unexpired Insurance...
[The following information applies to the questions displayed below.] On December 1, Year 1, John and Patty Driver formed a corporation called Susquehanna Equipment Rentals. The new corporation was able to begin operations immediately by purchasing the assets and taking over the location of Rent-It, an equipment rental company that was going out of business. The newly formed company uses the following accounts. Cash Capital Stock Accounts Receivable Retained Earnings Prepaid Rent Dividends Unexpired Insurance Income Summary Office Supplies Rental...
[The following information applies to the questions displayed below.] On December 1, Year 1, John and Patty Driver formed a corporation called Susquehanna Equipment Rentals. The new corporation was able to begin operations immediately by purchasing the assets and taking over the location of Rent-It, an equipment rental company that was going out of business. The newly formed company uses the following accounts. Cash Capital Stock Accounts Receivable Retained Earnings Prepaid Rent Dividends Unexpired Insurance Income Summary Office Supplies Rental...
[The following information applies to the questions displayed below.] On December 1, Year 1, John and Patty Driver formed a corporation called Susquehanna Equipment Rentals. The new corporation was able to begin operations immediately by purchasing the assets and taking over the location of Rent-It, an equipment rental company that was going out of business. The newly formed company uses the following accounts. Cash Capital Stock Accounts Receivable Retained Earnings Prepaid Rent Dividends Unexpired Insurance Income Summary Office Supplies Rental...