Sales Budget Formats

(1) Company Name Sales Budget (in units) For the period________ Region A B C Total

Month 1 Month 2 Month 3 Total XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX

Region A B C Total

(2) Company Name Sales Budget (in Rupees) For the period________ Month 1 Month 2 Month 3 Total XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX

Note: Sales price per unit will be given in question. It will be multiplied by Sales Budget in units. (3) Company Name Production Budget (in units) For the period________ Sales Budget (from sales budget units) Add: Desired Ending inventory (Given in question) Subtotal Less: opening inventory (Given in question) Productions units required

Month 1 Month 2 Month 3 Total XX XX XX XX XX XX XX XX XX XX

XX XX

XX XX

XX XX

(4) Company Name Direct Material purchases Budget (in units & Rupees) For the period________ Production units required (from production budget ) Add: Ending inventory (Given in question)

Month 1 Month 2 Month 3 Total XX XX XX XX

Subtotal Less: opening inventory (Given in question) Purchases required (units) X Cost per unit (Material cost ) Purchase Cost (Rs.)

XX

XX

XX

XX

XX XX

XX XX

XX XX

XX XX

XX XX XX

XX XX XX

XX XX XX

XX XX XX

(5) Company Name Direct Material usage Budget (in Rupees) For the period________ Production units required (from production budget ) X Cost per unit (Material cost ) Usage Cost (Rs.)

Month 1 Month 2 Month 3 Total XX XX XX XX XX XX

XX XX

XX XX

XX XX

(6) Company Name Direct Labor Budget (in Rupees) For the period________ Production units required (from production budget ) X Labor hours required per unit (Given in question) X Rate per hour (Given in question) Direct labor cost

Month 1 Month 2 Month 3 Total XX XX XX XX

(7)

XX

XX

XX

XX

XX XX

XX XX

XX XX

XX XX

Company Name FOH Budget (in Rupees) For the period________ It is combination of two Fixed & Variable expenses. 1. Fixed expense will be given normally month basis. 2. Variable Expense is calculated as Variable FOH rate (Given in Question) X Direct labor hours (Calculated in direct labor budget) (8) Company Name Cost of Goods Sold Budget For the period________ Direct Materials (From its budget ) Direct Labor (From its budget ) FOH (From its budget ) Total Manufacturing Cost Add: Finished good opening inventory (Given in question ) Cost of goods available for sale Less: Finished good ending inventory (Given in question ) Cost of Goods Sold

Month 1 Month 2 Month 3 Total XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX

XX XX

XX XX

XX XX

XX

XX

XX

XX

Company Name Budgeted income Statement For the period________ Month 1 Month 2 Month 3 Total XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX

Sales Less: COGS (From COGS Budget ) GP/Loss Less: Operating Expenses Selling (information given in question, normally %age given in question & calculated on sales) Admin (information given in question ) XX Income before Tax XX Income Tax (Rate will be given ) XX Net income  Format of cash budget is given in your handouts.

XX XX XX

XX XX XX

XX XX XX