FM11_Ch_22_P18_Build_a_Model - 7/5/2003 Chapter 22....

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

View Full Document Right Arrow Icon
7/5/2003 Chapter 22. Solution to Ch 22 P18 Build a Model Input Data Collections during month of sale 10% Collections during month after sale 75% Collections during second month after sale 15% Lease payments $9,000 Target cash balance $90,000 General and administrative salaries $27,000 Depreciation charges $36,000 $63,000 Miscellaneous expenses $2,700 New design studio payment $180,000 Cash on hand July 1 $132,000 Minimum cash balance $90,000 Sales, labor, and RM adjustment factor 0% May June July August September October November December January Original sales estimates $180,000 $180,000 $360,000 $540,000 $720,000 $360,000 $360,000 $90,000 $180,000 Original labor and raw mat. estimates $90,000 $90,000 $126,000 $882,000 $306,000 $234,000 $162,000 $90,000 Collections and purchases worksheet Sales (gross) Collections During month of sale During 1st month after sale During 2nd month after sale Total collections Purchases Labor and raw materials Payments for labor and raw materials
Background image of page 1

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

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

This note was uploaded on 03/16/2011 for the course FM 11 taught by Professor Teerana during the Spring '11 term at Thammasat University.

Page1 / 3

FM11_Ch_22_P18_Build_a_Model - 7/5/2003 Chapter 22....

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