Homework Help is Here – Start Your Trial Now!
Business
Finance
Give an evaluation or comment in the direct and indirect cost of the table

Give an evaluation or comment in the direct and indirect cost of the table

Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter22: Master Budget (master)
Section: Chapter Questions
Problem 6R
See similar textbooks
icon
Related questions
Question

Give an evaluation or comment in the direct and indirect cost of the table 

Month One-off orders made per month Subscription orders fulfilled Bags sold per month Gross revenue (value of goods) on one-off Discount and credit codes applied Net revenue Subscription revenue Gift vouchers purchased (£) Actual core product revenue Non-bag revenue Forknado Revenue Total revenue Average revenue per order Orders made by new customers Orders made by returning customers Share of repurchases Dinr Portions served Forknado Portions Served DIRECT COST Cost of ingredients - totals (Dinr) Cost of ingredients - totals (Forknado) Delivery cost Dinr Delivery cost Forknado Packing cost Cost per paper bag and all small packaging materials, letters (paper & printing), recipe sheets, ice pack etc Small stuff (Dinr only) Gift to customers (candle, chocolates etc) Transaction cost (paypal / stripe) VAT Other cost total direct cost Operating profit gross margin Oct 2012 Nov 1 2 43 48 811 326 486 105 591 0 591 19 35 8 685 191 0 84 52 51 24 77 1,034 -443 -75% 87 2,361 818 1,543 94 1,637 30 1,667 31 53 24 0 Dec 151 3 79 65 37 8 95 59 1105 343 782 18.60% 31.17% 43.24% 25.93% 43.24% 62 210 134 166 306 1,177 989.51 0 782 502 235.73 782 30 21 16 0 103 32 31 Jan 2013 Feb 4 5 1,983 1,391 -609 -316 -19% -78% 54 78 118 1228 2,224 493 589 1,636 769 179.56 949 949 23 40 14 74 0 75 1,711 136 1,711 30 42 697.26 1291.42 59 38 32 0 March Apr 6 7 36 332.28 591.56 215.76 64 68 61 913 194 719 37 0 205 106 711.69 500.35 28 34 857 25 18 18 50.00 % 43.24% 55.32% 122 122 182 61 91 880 1376.8 147.5 281 732.50 1,095.80 May 8 0 47 106 138.43 0 20 25 857 732.50 1,115.80 585.50 571.00 12 36 32 29 1,262 2,221 1,096 935 -314 -510 -238 -203 -33% -30% -28% -28% 2728 29 733 1,127.80 621.50 571.00 24 21 16 21 26 Jun 9 0 25 158 43 668 107.5 560.5 33 45 896.89 604.08 Jul 0 10 75 28 19 23 45 677 111 566 1,470 979 -342 -358 -31% -61% 267.3 336.78 258.34 124.22 192.96 085 Aug 0 11 78 16 19 23 358 0 27 24 12 12 13 16 52.00% 57.14% 75.00% 75.00% 86 90 60 42 610.82 372.49 358.00 27 4 12 30 21 310 431 73 46.72 358 263.28 0 52 Sept 7 12 14 12 59 263 190 500.00 26 3 9 29 39 219.54 460.93 137.36 52 5 11 855 639 885 -284 -281 -385 -50% -79% -146%
Transcribed Image Text:Month One-off orders made per month Subscription orders fulfilled Bags sold per month Gross revenue (value of goods) on one-off Discount and credit codes applied Net revenue Subscription revenue Gift vouchers purchased (£) Actual core product revenue Non-bag revenue Forknado Revenue Total revenue Average revenue per order Orders made by new customers Orders made by returning customers Share of repurchases Dinr Portions served Forknado Portions Served DIRECT COST Cost of ingredients - totals (Dinr) Cost of ingredients - totals (Forknado) Delivery cost Dinr Delivery cost Forknado Packing cost Cost per paper bag and all small packaging materials, letters (paper & printing), recipe sheets, ice pack etc Small stuff (Dinr only) Gift to customers (candle, chocolates etc) Transaction cost (paypal / stripe) VAT Other cost total direct cost Operating profit gross margin Oct 2012 Nov 1 2 43 48 811 326 486 105 591 0 591 19 35 8 685 191 0 84 52 51 24 77 1,034 -443 -75% 87 2,361 818 1,543 94 1,637 30 1,667 31 53 24 0 Dec 151 3 79 65 37 8 95 59 1105 343 782 18.60% 31.17% 43.24% 25.93% 43.24% 62 210 134 166 306 1,177 989.51 0 782 502 235.73 782 30 21 16 0 103 32 31 Jan 2013 Feb 4 5 1,983 1,391 -609 -316 -19% -78% 54 78 118 1228 2,224 493 589 1,636 769 179.56 949 949 23 40 14 74 0 75 1,711 136 1,711 30 42 697.26 1291.42 59 38 32 0 March Apr 6 7 36 332.28 591.56 215.76 64 68 61 913 194 719 37 0 205 106 711.69 500.35 28 34 857 25 18 18 50.00 % 43.24% 55.32% 122 122 182 61 91 880 1376.8 147.5 281 732.50 1,095.80 May 8 0 47 106 138.43 0 20 25 857 732.50 1,115.80 585.50 571.00 12 36 32 29 1,262 2,221 1,096 935 -314 -510 -238 -203 -33% -30% -28% -28% 2728 29 733 1,127.80 621.50 571.00 24 21 16 21 26 Jun 9 0 25 158 43 668 107.5 560.5 33 45 896.89 604.08 Jul 0 10 75 28 19 23 45 677 111 566 1,470 979 -342 -358 -31% -61% 267.3 336.78 258.34 124.22 192.96 085 Aug 0 11 78 16 19 23 358 0 27 24 12 12 13 16 52.00% 57.14% 75.00% 75.00% 86 90 60 42 610.82 372.49 358.00 27 4 12 30 21 310 431 73 46.72 358 263.28 0 52 Sept 7 12 14 12 59 263 190 500.00 26 3 9 29 39 219.54 460.93 137.36 52 5 11 855 639 885 -284 -281 -385 -50% -79% -146%
INDIRECT COST Rent Dinr Rent Forknado Utilities Chief culinary officer Chief executive and operating officer Operations manager Chief marketing officer Culinary Intern Marketing staff TOTAL STAFF COST Marketing & PR Insurance Recurring Tech/Phone Cost Entertainment Misc Kitchen equipment (consumables) Office equipment (consumables) Delivery equipment (consumables) Dinr Delivery equipment (consumables) Forknad Recruitment Indirect cost total EBITDA 533 22 1,200 1,200 430 142 533 22 1,200 533 22 1,200 1,200 1,200 2,162 1,119 142 142 533 22 1,200 1,200 446 142 533 22 600 600 4,509 142 533 22 941 941 630 142 533 22 1,232 533 22 533 533 22 1,200 600 533 22 1,200 750 750 533 22 1,200 750 750 1,232 533 1,800 2,700 399 853 293 447 142 142 142 21.5 10 86.25 193.23 10 142 143.66 96.33 159.36 94.71 48.68 35.27 10 9.6 14.13 19.77 10.28 5.05 65.18 8 326.74 431.07 4.8 533 670 22 1,200 1,200 575 2,700 2,975 137 456 142 153 86.86 73.89 42 47.86 200.4 253.5 45 42.3 2,327 4,060 3,016 2,344 5,807 5,557 2,268 2,446 3,097 3,124 4,015 3,748 -2,771 -4,375 -3,625 -2,658 -6,317 -2,507 -2,649 -3,439 -3,482 -4,299 -4,029 -5,942
Transcribed Image Text:INDIRECT COST Rent Dinr Rent Forknado Utilities Chief culinary officer Chief executive and operating officer Operations manager Chief marketing officer Culinary Intern Marketing staff TOTAL STAFF COST Marketing & PR Insurance Recurring Tech/Phone Cost Entertainment Misc Kitchen equipment (consumables) Office equipment (consumables) Delivery equipment (consumables) Dinr Delivery equipment (consumables) Forknad Recruitment Indirect cost total EBITDA 533 22 1,200 1,200 430 142 533 22 1,200 533 22 1,200 1,200 1,200 2,162 1,119 142 142 533 22 1,200 1,200 446 142 533 22 600 600 4,509 142 533 22 941 941 630 142 533 22 1,232 533 22 533 533 22 1,200 600 533 22 1,200 750 750 533 22 1,200 750 750 1,232 533 1,800 2,700 399 853 293 447 142 142 142 21.5 10 86.25 193.23 10 142 143.66 96.33 159.36 94.71 48.68 35.27 10 9.6 14.13 19.77 10.28 5.05 65.18 8 326.74 431.07 4.8 533 670 22 1,200 1,200 575 2,700 2,975 137 456 142 153 86.86 73.89 42 47.86 200.4 253.5 45 42.3 2,327 4,060 3,016 2,344 5,807 5,557 2,268 2,446 3,097 3,124 4,015 3,748 -2,771 -4,375 -3,625 -2,658 -6,317 -2,507 -2,649 -3,439 -3,482 -4,299 -4,029 -5,942
Expert Solution
steps

Step by step

Solved in 5 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Financial Accounting: The Impact on Decision Make…
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Essentials of Business Analytics (MindTap Course …
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
College Accounting, Chapters 1-27
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,
SEE MORE TEXTBOOKS