Question: Make a sample master budget for Skincare line business 1. Production budget A basic format of production budget is as follows: Sales forecast (in units)
Make a sample master budget for Skincare line business
1. Production budget
A basic format of production budget is as follows:
| Sales forecast (in units) |
| + Desired ending inventory of finished goods |
| Total budgeted production needs |
| Beginning inventory of finished goods |
| Required production |
2. Material Purchases Budget
The basic format of a material purchases budget is as follows:
| Raw materials needed to meet the required production budget |
| + Desired ending inventory of raw materials |
| Total raw materials needed |
| Beginning inventory of raw materials |
| = Raw materials to be purchased |
3. Summary Cash Budget
A basic summary cash budget is prepared in the following format:
| Beginning cash balance |
| + Cash receipts |
| Total cash available |
| Cash disbursements |
| =Cash balance before borrowing/repayment |
| +/ Borrowing from/repayment of line of credit |
| Interest on the credit |
| = Ending cash balance |
4. Budgeted Income Statement (Traditional)
A basic Budgeted Income Statement is prepared in the following format:
| Budgeted Income Statement (Traditional) | |
| Sales | P xxx |
| Less: Cost of goods sold | xxx |
| Gross Margin | xxx |
| Less: Selling and administrative expenses | xxx |
| Net operating income | xxx |
| Less: Interest expense | xxx |
| Income (before taxes) | xxx |
| Less: Income taxes | xxx |
| Net income | P xxx |
5. Budgeted Balance Sheet
A basic Budgeted Balance Sheet is prepared in the following format:
| Assets | |
| Current assets: | |
| Cash | P xxx |
| Accounts receivables | Xxx |
| Inventory: Direct materials | Xxx |
| Inventory: Finished goods | Xxx |
| Inventory: WIP | Xxx |
| Total current assets | Xxx |
| Fixed assets (net of depreciation) | Xxx |
| Total assets | Xxx |
| Liabilities and Equity | |
| Current liabilities: | |
| Accounts payable | Xxx |
| Line of credit | Xxx |
| Income tax | Xxx |
| Total current liabilities | Xxx |
| Long term liabilities | Xxx |
| Total liabilities | Xxx |
| Stockholders' Equity: | |
| Common stock | Xxx |
| Retained earnings | Xxx |
| Total stockholders' equity | Xxx |
| Total liabilities and stockholders' equity | Xxx |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
