Exam #3 (Ch.21) Excel Template

Exam #3 (Ch.21) Excel Template - SALES BUDGET January Sales...

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

View Full Document Right Arrow Icon
SALES BUDGET January February March Quarter April May Sales in units x Selling price Total Sales EXPECTED CASH COLLECTIONS January February March Quarter Nov. (33,000 x .05) Dec. (34,000 x .15) (34,000 x .05) Jan. (36,000 x .8) $0 (36,000 x .15) $0 (36,000 x .05) $0 Feb. (54,000 x .80) $0 (54,000 x .15) $0 March (39,000 x .80) $0 Totals $0 $0 $0 $0 PRODUCTION BUDGET January February March Quarter April May Sales in units Plus desired units of ending Fin. Goods Inv. Desired Total Units Less: desired units of beg. Fin. Goods Inv. Total production units DIRECT MATERIALS PURCHASES BUDGET
Background image of page 1

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

View Full DocumentRight Arrow Icon
January February March Quarter April Total production units x 3.3 lbs per unit Total production needs in lbs Plus desired lbs of end. Dir. Mat. Inv. Less desired lbs of beg. Dir Mat. Inv. Total lbs. of Dir. Mat. to be purchased x Cost per lb. Total cost of Dir. Mat. Purchased SCHEDULE OF EXPECTED CASH PAYMENTS FOR MATERIALS January February March Quarter A/P, Dec. 31, 2007 January February March Totals DIRECT LABOR BUDGET
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 5

Exam #3 (Ch.21) Excel Template - SALES BUDGET January Sales...

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

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