Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Implementing Change With Clinical Audit

Authors: Richard W. Baker, Hilary M. Hearnshaw, Noelle Robertson

1st Edition

0471982571, 978-0471982579

More Books

Students also viewed these Accounting questions