How to Calculate Projected Cost of Goods Sold

Projected cost of goods sold is just estimation and it is not on the basis of actual data. It is calculated for making better business plan and to minimize it. We know that when we calculate actual cost of goods sold, we can not decrease it because we can not change our history but we can change our future. So, to calculate projected cost of goods sold can help us in this.


Read on following steps to find out how.

Simple Way 


Actual cost of goods sold is

= Actual opening stock + Actual Net Purchase + Actual Direct Expenses  - Actual Closing Stock

And

Actual Gross Profit is

 = Actual Sale - Actual Cost of Goods Sold

Now, we can calculate Gross Profit % on sale

= Gross Profit / Sale X 100

Now, this Gross Profit % will help us to calculate the projected cost of goods sold.

For example, we have to calculate next year projected cost of goods sold when we have estimated next year sales. So, following formula will apply

Projected Cost of Goods Sold = Estimated Sales - Estimated Gross Profit

Estimated Gross Profit = Estimated Sales X Gross Profit %

Advance Way 


In advance way, we go more deep than simple way and for calculating projected cost of goods sold, we calculate following.

1. Determine Projected Beginning Inventory Value

We know that actual ending inventory value of previous year will become the beginning inventory. If you have good plan of consumption of this year, you can find the next year beginning inventory. For example, you can estimate next year's beginning inventory value as $ 30,000

2. Add the Value of All Projected Inventory Purchase 

Purchase department will have all the record of past purchases, purchase return. Net projected purchase can be calculated on past purchases and expectation of new sale. You can estimate it as $ 20,000.

3. Add Projected Direct Expenses 

Whether you are operating retail business or manufacturing, you will have lots of expenses which are related to purchase and manufacturing like direct labor cost, cost of freight, carriage inward etc. These expenses are effected from market condition. For example, India, I am seeing from past many years, labor cost increases only Rs. 50 every year in their per day wage. For example, in 2011, per day wages was Rs. 200. In 2012, per day wages was Rs. 250 and in 2013, per day wage is Rs. 300 and it is sure, in 2014, it will be Rs. 350 per day. Like my country's estimation, you can calculate your country's estimated rates of direct expenses. On this basis, you can calculate the total cost of projected direct expenses. For example, you can estimate it as $ 15000

4. Deduct Projected Ending Inventory Value 

To calculate the projected ending inventory's value is based on this year's closing stock's value. Closing stock's value is calculated on the basis of quantity of stock which is unsold and per unit cost. Per unit cost is calculated on the inventory method. If we will use FIFO, per unit cost will be different. If we will use LIFO, per unit cost will be different. For next year's projected ending inventory value will be based on the current year's closing stock's quantity, future sale quantity expectation and future using of inventory valuation method. For example, our projected ending inventory value is $ 30,000.

So, Projected Cost of Goods Sold = 

Projected Beginning Inventory Value + All Projected Inventory Purchase + Projected Direct Expenses - Projected Ending Inventory Value 

$ 30,000 + $ 20,000 + $ 15000 -  $ 30,000 = $ 35000

Following is the performa for calculating of projected cost of goods sold of a manufacturing company.

Projected Direct Material


Estimated Raw Material Inventory XXXXX
Add : Purchase of Raw Material (Estimated) XXXXX
Deduct : Ending Raw Material (Estimated ) XXXXX
Total Projected Direct Material Cost XXXXX
Projected Direct Labor Cost
Estimation of Direct labor cost XXXXX
Total Projected Direct Labor Cost XXXXX
Projected Manufacturing Overhead
Indirect Labor (Estimated) XXXXX
Factory Utilities (Estimated) XXXXX
Direct Supplies (Estimated) XXXXX
Factory Depreciation (Estimated) XXXXX
Factory Property Texes (Estimated) XXXXX
Factory Insurance (Estimated) XXXXX
Total Projected Manufacturing Overhead XXXXX
+ Beginning Work in Process Inventory (Estimated) + XXXXX
- Ending Work in Process Inventory (Estimated) - XXXXX
+ Finished stock at beginning (Estimated) + XXXXX
- Finished Stock at Ending  (Estimated) - XXXXX
Projected Cost of Goods Sold  XXXXX

See Also


COMMENTS

Comments on this Website
.
Share above Content to Your Friends



Name

access account accountant Accounting accounting definitions accounting ebook Accounting education accounting procedure accounting process outsourcing Accounting Software advance advertising africa Amalgamation amendments announcements Annuity assets audit auditing Australia B.Com. balance sheet bank Bank reconciliation banking basic accounting BBA benefits best bill black money blog bloggers book keeping bookkeeping Branch Accounting - full tutorial budget Budget variance business businessman CA calculator canada capital capital budgeting career cash cash book cash flow statement Chiense children china class coaching coins college commerce commerce students company computer computer accounting conference Contact vinod kumar corporate accounting cost cost accounting cost center cost centre CPA credit credit card cs currency data Debit and credit debit cards debt debtor degree depletion depreciation documents dollar domain Downloads Dubai e-accounting earning education Education Loans email employee EPF ERP euromoney examination excel excise duty expenses facebook factor of loan fans feature fifo FII fiji finacle finance Financial financial accounting fire insurance flickr flow forensic forex formula france fraud free fun function fund GAAP GDP gdr germany gold goodwill goodwill accounting google google apps google apps google base google buzz google calendar Google docs google finance google fusion tables google talk govt. GST guide health Hindi Hindi Language history holding company How to treat FBT in Tally 9 HRA ICAI ICAWI ICICI Bank IFRS income income statement Income Tax India indian railway Indonesia inflation inflation accounting infographics information inspiration insurance insurance accounting interest international Internet Introduction of Tally 9 inventory investment invoice IT Japan Job costing journal entries Kalculate keyboard kindle kuwait laptop law LBT learning lease lecture ledger leducation Leverage Analysis liabilities lifo linkedin loan logical point loss loss of profit M.Com. m.phil malaysia management accounting manual accounting manufacturing account market marketing mastercard material MBA MCA media migration mobile money ms word ms. excel multi currency in tally 9 Multicurrency Accounting mutual fund national security new and sacrifice ratio new york times new zealand news NGO nonprofit-accounting North Georgia Mountains NPV NSE odbc office oman online application online accounting otcei pakistan parents pay pal pdf pie chart pie chart of income pnb podcast ppf presentation price privacy policy prize money prof. vinod kumar profit profit and loss account project management provision purchase puzzles quickbooks Quote quotes quotes of svtuition rating agency ratio analysis RBI readers real estate rectification of errors remote control reports reserves responsibility accounting retirement revenue Revenue reserves review risk rupees salary sale saudi arabia saving sbi scholarship school SEBI security service tax share share trading Shares shri lanka singapore sms social accounting society solution South Africa stock stock exchange structure student students study subsidiary company svtuition swiss bank tally tally 9 Tally 7.2 Tally 9 Tally.ERP 9 tanzania tax Tax Accounting TDS teacher teaching technology test testimonial testimonials thailand tips trading trading on equity transaction trend trial balance tuition twitter UAE UGC - NET Commerce UK United Arab Emirates university usa valuation VAT Video Voucher and vouching wikipedia working capital youtube
false
ltr
item
Accounting Education: How to Calculate Projected Cost of Goods Sold
How to Calculate Projected Cost of Goods Sold
Accounting Education
http://www.svtuition.org/2013/12/how-to-calculate-projected-cost-of.html
http://www.svtuition.org/
http://www.svtuition.org/
http://www.svtuition.org/2013/12/how-to-calculate-projected-cost-of.html
true
2410664366776677676
UTF-8
Not found any lecture VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES Lectures View All RECOMMENDED FOR YOU Category ARCHIVE SEARCH ALL Lectures Not found any lecture match with your request, please help to write it and send it to our email at vinod@svtuition.org for making this website free accounting and finance encyclopedia. Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS CONTENT IS PREMIUM Please share to unlock