CourseLover

(12)

$10/per page/Negotiable

About CourseLover

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Algebra,Applied Sciences See all
Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Engineering,Health & Medical,HR Management,Law,Marketing,Math,Physics,Psychology,Programming,Science Hide all
Teaching Since: May 2017
Last Sign in: 317 Weeks Ago, 5 Days Ago
Questions Answered: 27237
Tutorials Posted: 27372

Education

  • MCS,MBA(IT), Pursuing PHD
    Devry University
    Sep-2004 - Aug-2010

Experience

  • Assistant Financial Analyst
    NatSteel Holdings Pte Ltd
    Aug-2007 - Jul-2017

Category > Accounting Posted 20 Dec 2017 My Price 10.00

Estimating Quantity Sold in Sept

please look at week 2 and complete what is asking for. it can be done on the same tab.

                 
Estimating Quantity Sold in Sept - Dec 2015            
Let x be Qty sold from October to March and hence 2x is the quantity sold from April to September      
     
Hence X/2+2X*5/6 = 440000   (Period from January to August 2015)      
Therefore X= 203077                
Assuming sales to be distributed uniformly            
Demand for September = 2X/6 = X/3            
Demand for October - December = (X/6)*3            
Net Demand = X/3+X/2 = 169230              
We will assume it to be 170000 for making simplified calculations        
                 
Particulars 2014 2015 (August YTD) 2015 (Full Year) 2016 Remarks for 2015 Remarks for 2015    
Volume           608,000           440,000               610,000           640,500        
Sales       7,600,000       5,500,000           7,625,000       8,006,250 Estimated based on pricing till August 2015 Estimated based on pricing till August 2015    
                 
Expense Category                
Raw Material       3,040,000       2,200,000           3,050,000       3,202,500 Assumed to vary in accordance to volume Assumed to vary in accordance to volume *Efficiency Improvement will have no effect  
Salaries and Wages           775,000           533,000               799,500           823,485   3% increase    
Fringe Benefits           372,000           262,000               393,000           411,743 Assumed to vary in accordance to wages 50% of Wages    
Travel & Entertainment             30,000             22,000                 33,000             36,300 Assumed to vary monthly Inflation accounted for in reference to 2014 and 2015    
Outside Contractors           140,000             80,000               120,000           160,000 Assumed to vary monthly 4 contractors    
Manufacturing Supplies           250,000           160,000               221,818           229,415 Assumed to vary in accordance to volume Assumed to vary in accordance to volume *Volume related cost reduces by 3% for 2nd Half  
Parts and Tools             60,000             40,000                 55,455             57,354 Assumed to vary in accordance to volume Assumed to vary in accordance to volume  
Utilities           300,000           220,000               305,000           315,446 Assumed to vary in accordance to volume Assumed to vary in accordance to volume  
Depreciation           150,000           110,000               165,000           171,500 Assumed to vary monthly Assumed to net of depreciation of 2015 + Depreciation of New Mixing Machine    
Warehousing Costs             80,000             50,000                 68,278             71,692 Assumed to vary in accordance to volume Assumed to vary in accordance to volume *Volume related cost reduces by 3% for 2nd Half  
Loan                   400,000           800,000 Paid at the end of December 2015 Paid at the end of December 2016    
Interest                     16,000             32,000 Interest calculated on 1200000 Interest calculated on 800000    
Total Operating Expenses       5,197,000       3,677,000           5,627,051       6,311,435        
Sales and Advertising Exp           450,000           300,000               415,909     436,704.55 Assumed to vary in accordance to volume Assumed to vary in accordance to volume *Efficiency Improvement will have no effect  
                 
Income from Operations       1,953,000       1,523,000           1,582,040       1,258,110   subtracted operating expense subtracted operating expenses  
                 
                 
                 
Background image of page 1

Answers

CourseLover
(12)
Status NEW Posted 20 Dec 2017 06:12 AM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------usi-----------ng -----------our----------- we-----------bsi-----------te -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------ns.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age-----------

Not Rated(0)