Excel Project - Administrative $53,125.21 $77,095.17...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Exam Spreadsheet Page 1 PLANT A TREE, INC. QUARTERLY REPORT - JANUARY THROUGH MARCH Prepared by Bailee Milner Apr-11 January February March Total Revenue Sales Revenue $300,000.75 $450,000.50 $650,000.77 $1,400,002.02 Other Revenue $12,500.50 $3,500.50 $2,150.75 $18,151.75 Total Revenue $312,501.25 $453,501.00 $652,151.52 $1,418,153.77 Expenses Maufacturing $118,750.48 $172,330.38 $247,817.58 $538,898.43 Research $34,375.14 $49,885.11 $71,736.67 $155,996.91 Marketing $50,000.20 $72,560.16 $104,344.24 $226,904.60
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Administrative $53,125.21 $77,095.17 $110,865.76 $241,086.14 Fulfillment $25,000.10 $36,280.08 $52,172.12 $113,452.30 Total Expenses $281,251.13 $408,150.90 $586,936.37 $1,276,338.39 Net Income $31,250.13 $45,350.10 $65,215.15 $141,815.38 Assumptions Manufacturing 38% Research 11% Marketing 16% Administrative 17% Fulfillment 8% Pie Chart Page 2 1 22% 2 $45,350.10 32% 3 $65,215.15 46% Plant A Tree, Inc. 1 2 3 Efforts are underway to improve January sales figures...
View Full Document

Page1 / 2

Excel Project - Administrative $53,125.21 $77,095.17...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online