| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | APP ESTIMATE | |||||||||||||||||||||||||
2 | Revenue | MO 01 | MO 02 | MO 03 | MO 04 | MO 05 | MO 06 | MO Sub TOTAL | ||||||||||||||||||
3 | In-App Purchases | $2,498.33 | $27,988.33 | $19,444.28 | $22,342.60 | $34,139.06 | $66,926.77 | $173,339.36 | (users * purchase rate) * price | |||||||||||||||||
4 | In-App Ads | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||
5 | One-Time Download Payment | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||
6 | Subscriptions | $2,164.50 | $24,248.46 | $16,846.09 | $19,357.12 | $29,577.32 | $57,983.85 | $150,177.34 | (users * sub rate) * price | |||||||||||||||||
7 | Sales (e-commerce) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||
8 | SUBTOTAL | $4,662.83 | $52,236.79 | $36,290.37 | $41,699.72 | $63,716.37 | $124,910.62 | $323,516.70 | TOTAL 6 MO REVENUE | |||||||||||||||||
9 | Original Creation Expenses | App is launched | ||||||||||||||||||||||||
10 | ROLE | AMOUNT | UNIT | X | RATE | TAB | TOTAL | Expenses | MO 01 | MO 02 | MO 03 | MO 04 | MO 05 | MO 06 | MO Sub TOTAL | |||||||||||
11 | Preparation and Management | PWA specification development (needs analysis/content planning/structure design) | 30 | hrs | 1 | $52 | $1,560 | Servers / Cloud | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $240.00 | (Lahn, 2022) | ||||||||||
12 | UI/UX Design | 76 | hrs | 1 | $48 | $3,648 | Front-End Maintenance | $3,000.00 | $3,000.00 | $3,000.00 | $3,000.00 | $3,000.00 | $3,000.00 | $18,000.00 | (Snyder, 2022) | |||||||||||
13 | UI/UX Wireframing (Adobe XD) | 50 | hrs | 1 | $48 | $2,400 | Back-End Maintenance | $3,000.00 | $3,000.00 | $3,000.00 | $3,000.00 | $3,000.00 | $3,000.00 | $18,000.00 | (Snyder, 2022) | |||||||||||
14 | UI/UX Draft Review / Clearance | 18 | hrs | 1 | $48 | $864 | Ecommerce Fees | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
15 | Administration (preparation of contract/estimate, digital and paper file management, tracking hours, invoicing) | 5 | hrs | 1 | $52 | $260 | Content / Production | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
16 | Meetings, phone calls, email correspondence with client | 20 | hrs | 1 | $75 | $1,500 | Marketing per month | $699.43 | $7,835.52 | $5,443.55 | $6,254.96 | $9,557.46 | $18,736.59 | $48,527.51 | (Snyder, 2022) | 30-50% | ||||||||||
17 | Supervision of subcontractors /team | 24 | hrs | 1 | $75 | $1,800 | Advertising per month | $699.43 | $7,835.52 | $5,443.55 | $6,254.96 | $9,557.46 | $18,736.59 | $48,527.51 | (Snyder, 2022) | 30-50% | ||||||||||
18 | Route Design | Creation of routes | 10 | hrs | 1 | $55 | $550 | (Snyder, 2022) | Apple/Google cut (30%) | $1,398.85 | $15,671.04 | $10,887.11 | $12,509.92 | $19,114.91 | $37,473.19 | $97,055.01 | 30% | |||||||||
19 | Creation of text/editing/spelling/grammar | 10 | hrs | 1 | $55 | $550 | (SpdLoad, n.d.) | $230,350.02 | TOTAL 6 MO Maintenance & Expansion Costs | |||||||||||||||||
20 | Creation of UI/UX buttons | 40 | hrs | 1 | $55 | $2,200 | (SpdLoad, n.d.) | |||||||||||||||||||
21 | Creation of photos/opt | 0 | hrs | 1 | $55 | $0 | ||||||||||||||||||||
22 | Creation of video content | 0 | hrs | 1 | $55 | $0 | NOTATIONS | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | SUBTOTAL | ||||||||||||
23 | Creation of 3D graphics | 36 | hrs | 1 | $55 | $1,980 | (SpdLoad, n.d.) | Users per month | 3333 | 37343 | 25943 | 29810 | 45549 | 89295 | 231273 | (Buildfire, 2022) | ||||||||||
24 | PWA Review/ Clearance 01 | 3 | hrs | 1 | $52 | $156 | Downloads per month | 10000 | 112028 | 77829 | 89430 | 136647 | 267886 | 693820 | (See Assumptions Page) | |||||||||||
25 | Route Constrution | Organizing and managing gathering of content from client, including specifying target keywords/keyphrases for SEOs | 34 | hrs | 1 | $75 | $2,550 | In-App Purchases % | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | (Buildfire, 2022) | |||||||||||
26 | Produce home route | 30 | hrs | 1 | $67 | $2,010 | (Snyder, 2022) | Subscripition Rate | 6.50% | 6.50% | 6.50% | 6.50% | 6.50% | 6.50% | (Ceci, 2022) | |||||||||||
27 | Design routes (4) | 50 | hrs | 1 | $67 | $3,350 | (Snyder, 2022) | Churn rate % per month | 19.00% | 22.00% | 23.00% | 24.00% | 24.00% | 24.00% | (Ceci, 2021) | |||||||||||
28 | Forms (consider number of fields, validation, scripts for processing data, testing/troubleshooting | 15 | hrs | 1 | $67 | $1,005 | (Didenko, 2022) | |||||||||||||||||||
29 | HIPPA/ COPPA/ GDRP/ (notations) | 5 | hrs | 1 | $67 | $335 | (Your Europe, 2022) | |||||||||||||||||||
30 | Push notifications (front-end) | 0 | hrs | 1 | $67 | $0 | $323,516.70 | TOTAL 6 MO REVENUE | ||||||||||||||||||
31 | Social Media (API) - sharing | 0 | hrs | 1 | $67 | $0 | $230,350.02 | TOTAL 6 MO Maintenance & Expansion Costs | ||||||||||||||||||
32 | Widget (Front-end design for additional server side features) | 45 | hrs | 1 | $67 | $3,015 | (Crowdbotics, n.d.) | $75,168 | TOTAL Original Cost to build | |||||||||||||||||
33 | Location / GEO | 30 | hrs | 1 | $67 | $2,010 | (Crowdbotics, n.d.) | $305,518.02 | TOTAL ALL EXPENSES (Original Cost + 6 Months of Maintenance) | |||||||||||||||||
34 | Payment/ Ecommerce | 0 | hrs | 1 | $67 | $0 | ||||||||||||||||||||
35 | Gamification / AR / QR Codes | 74 | hrs | 1 | $67 | $4,958 | (Snyder, 2022) | NET PROFIT | $17,998.68 | Revenue - total expenses | ||||||||||||||||
36 | Team Coordination Phase 2 | 34 | hrs | 1 | $75 | $2,550 | ||||||||||||||||||||
37 | Server-Side Application Building | Specification development for dynamic applications | 15 | hrs | 1 | $80 | $1,200 | (Didenko, 2022) | ||||||||||||||||||
38 | HIPPA/ COPPA/ GDRP/ | 5 | hrs | 1 | $80 | $400 | (Martinez, 2018) | |||||||||||||||||||
39 | AI/Machine learning | 55 | hrs | 1 | $80 | $4,400 | ||||||||||||||||||||
40 | Push Notications | 0 | hrs | 1 | $80 | $0 | ||||||||||||||||||||
41 | Designing and building databases | 30 | hrs | 1 | $80 | $2,400 | (Snyder, 2022) | |||||||||||||||||||
42 | Designing and coding dynamic applications | 30 | hrs | 1 | $80 | $2,400 | (Didenko, 2022) | |||||||||||||||||||
43 | Building admin sections | 0 | hrs | 1 | $80 | $0 | ||||||||||||||||||||
44 | Combining code with PWA | 0 | hrs | 1 | $80 | $0 | ||||||||||||||||||||
45 | Testing, troubleshooting and finalizing data-driven pages | 57 | hrs | 1 | $80 | $4,560 | (Snyder, 2022) | |||||||||||||||||||
46 | Team Coordination Phase 3 | 32 | hrs | 1 | $75 | $2,400 | ||||||||||||||||||||
47 | Completion and Wrap-Up | Client training (for admin sections, checking site statistics) | 14 | hrs | 1 | $52 | $728 | |||||||||||||||||||
48 | Domain registration/DNS changes/hosting arrangements, setup of client email addresses | 5 | hrs | 1 | $67 | $335 | (Wilson & Zamora, 2022) | |||||||||||||||||||
49 | Uploading, testing and finalizing completed PWA | 0 | hrs | 1 | $67 | $0 | ||||||||||||||||||||
50 | Client training (For front-end maintenance) | 8 | hrs | 1 | $52 | $416 | ||||||||||||||||||||
51 | Submit PWA to search engines/directories | 0 | hrs | 1 | $67 | $0 | ||||||||||||||||||||
52 | Other (anything not yet included – secondary page designs, complex menus, scripts etc.) | 36 | hrs | 1 | $52 | $1,872 | ||||||||||||||||||||
53 | ||||||||||||||||||||||||||
54 | ||||||||||||||||||||||||||
55 | Total hrs: 96 | SUB -TOTAL Business Team Hours | 96 | hrs | 1 | $52 | $4,992 | |||||||||||||||||||
56 | Total hrs: 144 | SUB -TOTAL UI/UX Design Hours | 144 | hrs | 1 | $48 | $6,912 | |||||||||||||||||||
57 | Total hrs: 144 | SUB -TOTAL Project Management Hours | 144 | hrs | 1 | $75 | $10,800 | |||||||||||||||||||
58 | Total hrs: 192 | SUB -TOTAL Back-End Server Programmer Team Hours | 192 | hrs | 1 | $80 | $15,360 | |||||||||||||||||||
59 | Total hrs: 96 | SUB -TOTAL DESIGN TEAM HOURS | 96 | hrs | 1 | $55 | $5,280 | |||||||||||||||||||
60 | Total hrs: 288 | SUB -TOTAL Front-End Programmer Team Hours | 288 | hrs | 1 | $67 | $19,296 | |||||||||||||||||||
61 | TOTAL HOURS | 960 | hrs | |||||||||||||||||||||||
62 | TOTAL BUDGET | $62,640 | ||||||||||||||||||||||||
63 | Contingency / Overage 10% | $6,264.0 | ||||||||||||||||||||||||
64 | G & A Expenses (office, Marketing, office expense, payroll taxes, insurance) | $12,528.0 | ||||||||||||||||||||||||
65 | TOTAL APP DEVELOPMENT COSTS (App Expenses + G&A Expenses) | $75,168 | ||||||||||||||||||||||||
66 | CLIENT USE ONLY | PROFIT MARGIN (at least 20%, but something that the market will bear) | $15,033.6 | Only use this line for a future client. | ||||||||||||||||||||||
67 | CLIENT USE ONLY | TOTAL COSTS for the CLIENT ESTIMATE (The sum you hand a client in an estimate) | $96,465.6 | Only use this line for a future client. | ||||||||||||||||||||||
68 | ||||||||||||||||||||||||||
69 | ||||||||||||||||||||||||||
70 | ||||||||||||||||||||||||||
71 | ||||||||||||||||||||||||||
72 | ||||||||||||||||||||||||||
73 | ||||||||||||||||||||||||||
74 | ||||||||||||||||||||||||||
75 | ||||||||||||||||||||||||||
76 | ||||||||||||||||||||||||||
77 | ||||||||||||||||||||||||||
78 | ||||||||||||||||||||||||||
79 | ||||||||||||||||||||||||||
80 | ||||||||||||||||||||||||||
81 | ||||||||||||||||||||||||||
82 | ||||||||||||||||||||||||||
83 | ||||||||||||||||||||||||||
84 | ||||||||||||||||||||||||||
85 | ||||||||||||||||||||||||||
86 | ||||||||||||||||||||||||||
87 | ||||||||||||||||||||||||||
88 | ||||||||||||||||||||||||||
89 | ||||||||||||||||||||||||||
90 | ||||||||||||||||||||||||||
91 | ||||||||||||||||||||||||||
92 | ||||||||||||||||||||||||||
93 | ||||||||||||||||||||||||||
94 | ||||||||||||||||||||||||||
95 | ||||||||||||||||||||||||||
96 | ||||||||||||||||||||||||||
97 | ||||||||||||||||||||||||||
98 | ||||||||||||||||||||||||||
99 | ||||||||||||||||||||||||||
100 |