Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help making a 12 month budget report for a hypothetical e-commerce shoe insole company. the data is as follows: Revenue: 2,500 units sold
I need help making a 12 month budget report for a hypothetical e-commerce shoe insole company. the data is as follows: Revenue: 2,500 units sold per month Profit per unit: $69,849 / 2,500 = $27.94 Monthly revenue: 2,500 x $27.94 = $69,850 Expenses: Factory rent: $5,000 Equipment depreciation: $6,250 (=$75,000 / 12) Raw materials: Cork: $1,000 Recyclable materials: $120 Sustainable materials: $1,000 Total raw materials cost: $2,120 Transportation: $10,000 Advertising and marketing: Business signage: $1,000 Inventory expenses: Upfront inventory costs: $5,000 Inventory storage: $5,000 Package design: $3,000 Shrinkage: $1,000 Distribution costs: $750 Total inventory expenses: $14,750 Software expenses: Accounting & Invoicing Software: $50 Project Management Software: $25 Total software expenses: $75 Total monthly expenses: $38,995 Net profit per month: $69,850 - $38,995 = $30,855 I need it shown in an excel (rows and columns) format
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started