In: Accounting
E7.1 A company’s annual sales budget is for 120 000 units spread equally through the year. It needs tohave one-and-a-half months’ inventory at the end of each month. Each unit purchased costs $15and is sold for $25. If opening inventory is 12 000 units, calculate the budgeted cost of purchases inthe first month of the budget year.
1 | Advice | |||||||||||||
Sales-Last Year | Agreed Target | |||||||||||||
Sales | 12,000,000 | 13,200,000 | ||||||||||||
(12,000,000 X 1.10) | ||||||||||||||
If Sales is < 13,200,000 | ||||||||||||||
Commission-Max | 264,000 | |||||||||||||
If Sales is > 13,200,000 | ||||||||||||||
Commission-Minimum | 660,000 | |||||||||||||
2 | Annual sales | 120,000 | ||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total | ||
Opening Inventory | 12,000 | 15,000 | 15,000 | 15,000 | 15,000 | 14,999 | 14,996 | 14,988 | 14,963 | 14,889 | 14,667 | 14,000 | ||
Purchase | 10,000 | 10,000 | 10,000 | 10,000 | 9,999 | 9,997 | 9,992 | 9,975 | 9,926 | 9,778 | 9,333 | 8,000 | 117,000 | |
(12000/1.5) | ||||||||||||||
sales | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 | ||
Closing Inventory | 15,000 | 15,000 | 15,000 | 15,000 | 14,999 | 14,996 | 14,988 | 14,963 | 14,889 | 14,667 | 14,000 | 12,000 | ||
Units | Rate | Amount | ||||||||||||
Cost of Purchase | 117,000 | 15 | 1,755,000 | |||||||||||