Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Sales Budget April May June July Budgeted Units 20,500.00 19,500.00 20,000.00 60,000.00 Budgeted Unit Sales Price 23.85 23.85 23.85 Budgeted Sales in Dollars 488,925.00 465,075.00
Sales Budget | ||||
April | May | June | July | |
Budgeted Units | 20,500.00 | 19,500.00 | 20,000.00 | 60,000.00 |
Budgeted Unit Sales Price | 23.85 | 23.85 | 23.85 | |
Budgeted Sales in Dollars | 488,925.00 | 465,075.00 | 477,000.00 | 1,431,000.00 |
Total | 509,425.00 | 484,575.00 | 497,000.00 | 1,491,000.00 |
Production Budget | ||||
April | May | June | Quarter | |
Next Period's budgeted sales | 19,500.00 | 20,000.00 | 20,500.00 | 60,000.00 |
Ratio of inventory to future sales | 0.80 | 0.80 | 0.80 | |
Budgeted ending inventory | 15,600.00 | 16,000.00 | 16,400.00 | 48,000.00 |
Add Budgeted Sales | 20,500.00 | 19,500.00 | 20,000.00 | 60,000.00 |
Required units to be produced | 36,100.00 | 35,500.00 | 36,400.00 | 108,000.00 |
Less Beginning Inventory | 16,400.00 | 15,600.00 | 16,000.00 | 48,000.00 |
Units to be produced | 19,700.00 | 19,900.00 | 20,400.00 | 60,000.00 |
Raw Matarials Budget | ||||
April | May | June | Quarter | |
Production budget (units) | 19,700.00 | 19,900.00 | 20,400.00 | 60,000.00 |
Materials requirement per unit | 0.50 | 0.50 | 0.50 | |
Materials needed for production | 9,850.00 | 9,950.00 | 10,200.00 | 30,000.00 |
Add budgeted Inventory | 4,975.00 | 5,100.00 | 4,000.00 | 14,075.00 |
Total materials requirement (units) | 14,825.00 | 15,050.00 | 14,200.00 | 44,075.00 |
Less Beginning Inventory | 4,925.00 | 4,975.00 | 5,100.00 | 15,000.00 |
Materials to be purchased | 9,900.00 | 10,075.00 | 9,100.00 | 29,075.00 |
Material price per unit | 20.00 | 20.00 | 20.00 | |
Total cost of direct materials purchased | 198,000.00 | 201,500.00 | 182,000.00 | 581,500.00 |
Direct Labor Budget | ||||
April | May | June | Quarter | |
Budgeted production (units) | 19,700.00 | 19,900.00 | 20,400.00 | 60,000.00 |
Labor requirements per unit (hours) | 0.50 | 0.50 | 0.50 | |
Total hours needed | 9,850.00 | 9,950.00 | 10,200.00 | 30,000.00 |
Labor rate (per hour) | 15.00 | 15.00 | 15.00 | |
Labor dollars | 147,750.00 | 149,250.00 | 153,000.00 | 450,000.00 |
Factory Overhead Budget | ||||
April | May | June | Quarter | |
Labor hours needed | 9,850.00 | 9,950.00 | 10,200.00 | 30,000.00 |
Variable factory overhead rate | 2.70 | 2.70 | 2.70 | |
Budgeted variable overhead | 26,595.00 | 26,865.00 | 27,540.00 | 81,000.00 |
Fixed Overhead | 20,000.00 | 20,000.00 | 20,000.00 | 60,000.00 |
Budgeted total overhead | 46,595.00 | 46,865.00 | 47,540.00 | 141,000.00 |
Selling Expenses Budgets | ||||
April | May | June | Total | |
Budgeted Sales | 488,925.00 | 46,075.00 | 477,000.00 | 1,431,000.00 |
Sales commission percent | 0.08 | 0.08 | 0.08 | |
Sales commission expense | 3,911,400.00 | 37,206.00 | 38,160.00 | 114,480.00 |
Sales Salaries | 3,000.00 | 3,000.00 | 3,000.00 | |
Total Selling Expenses | 42,114.00 | 40,206.00 | 41,160.00 | 123,480.00 |
General and Administrative Expenses | ||||
April | May | June | Total | |
Salaries | 12,000.00 | 12,000.00 | 12,000.00 | 36,000.00 |
Interest on long-term note | 4,500.00 | 4,500.00 | 4,500.00 | 13,500.00 |
Total Expenses | 16,500.00 | 16,500.00 | 16,500.00 | 49,500.00 |
Cash Receipts from Customers | ||||
April | May | June | Total | |
Total Sales | 488,925.00 | 465,075.00 | 477,000.00 | 1,431,000.00 |
Cash Sales (30%) | 146,677.50 | 139,522.50 | 143,100.00 | 429,300.00 |
Credit sales (70%) | 342,247.50 | 325,552.50 | 333,900.00 | 1,001,700.00 |
Cash Collections | ||||
Month after sale (100%) | 342,248.00 | 342,247.50 | 325,552.50 | 1,010,048.00 |
Cash Sales | 146,677.50 | 139,522.50 | 143,100.00 | 429,300.00 |
Total Cash Received | 488,925.50 | 481,770.00 | 468,652.50 | 1,439,348.00 |
Budgeted Cash Payments for Purchases | ||||
April | May | June | Quarter | |
Credit Purchases | 198,000.00 | 201,500.00 | 182,000.00 | 581,500.00 |
Cash Payment | ||||
Month After Purchase | 200,500.00 | 198,000.00 | 201,500.00 | 600,000.00 |
Cash Budget | ||||
April | May | June | ||
Beginning Cash Balance | 40,000.00 | 83,346.50 | 124,175.50 | |
Cash Receipts from Customers | 488,925.50 | 481,770.00 | 468,652.50 | |
Total Cash Available | 528,925.50 | 565,116.50 | 592,828.00 | |
Cash Disbursements: | ||||
Payments for raw materials | 200,500.00 | 198,000.00 | 201,500.00 | |
Payments for direct labor | 147,750.00 | 149,250.00 | 153,000.00 | |
Payments for variable overhead | 26,595.00 | 26,865.00 | 27,540.00 | |
Sales Commissions | 39,114.00 | 37,206.00 | 38,160.00 | |
Sales Salaries | 3,000.00 | 3,000.00 | 3,000.00 | |
General & Administrative Salaries | 12,000.00 | 12,000.00 | 12,000.00 | |
Dividends | 10,000.00 | |||
Loan Interest | 120.00 | 120.00 | 120.00 | |
Long-Term note interest | 4,500.00 | 4,500.00 | 4,500.00 | |
Equipment Purchases | 130,000.00 | |||
Total Cash Disbursements | 433,579.00 | 440,941.00 | 569,820.00 | |
Preliminary cash balance | 95,346.50 | 124,175.50 | 23,008.00 | |
Additional loan | 16,992.00 | |||
Repayment of loan to bank | 12,000.00 | |||
Ending Cash Balance | 83,346.50 | 124,175.50 | 40,000.00 | |
Loan Balance, end of month | 16,992.00 | |||
Budgeted Income Statement | ||||
Zigby Manufacturing | ||||
Budgeted Income Statement | ||||
For the Quarter ended June 30, 2013 | ||||
Sales | 143,100.00 | |||
Cost of Goods Sold | 1,191,000.00 | |||
Gross Profit | 240,000.00 | |||
Operating Expenses | 114,480.00 | |||
Sales Comminssions | 9,000.00 | |||
Sales Salaries | 36,000.00 | |||
General Admin Expenses | 13,500.00 | |||
Long-Term Note Interest | 120.00 | 173,100.00 | ||
Interest Expense | 66,900.00 | |||
Income Before Taxes | 23,415.00 | |||
Income Taxes | 23,415.00 | |||
Net Income | 43,485.00 | |||
Budgeted Balance Sheet | ||||
Zigby Manufacturing | ||||
Budgeted Balance Sheet | ||||
41,455.00 | ||||
ASSETS | ||||
Cash | 40,000.00 | |||
Accounts Receivable | 333,900.00 | Note 1 | ||
Raw Materials Inventory | 80,000.00 | Note 2 | ||
Finished Goods Inventory | 325,540.00 | Note 3 | ||
Total current assets | 779,440.00 | |||
Equipment | 730,000.00 | Note 4 | ||
Less: accumulated depreciation | 210,000.00 | 520,000.00 | Note 5 | |
Total Assets | 1,299,440.00 | |||
LIABILITIES AND EQUITY | ||||
Accounts Payable | 182,000.00 | Note 6 | ||
Bank Loan Payable | 16,752.00 | |||
Taxes Payable | 23,415.00 | |||
Total current liabilities | 222,167.00 | |||
Long-term note payable | 500,000.00 | |||
Common stock | 335,000.00 | |||
Retained Earnings | 242,273.00 | |||
Total stockholders' equity | 577,273.00 | |||
Total Liabilities and Equity | 1,299,440.00 |
|
GIVEN THE ABOVE INFORMATION, CALCULATE THE FOLLOWING TABLES
Budgeted Statement of Retained Earnings | ||||||||||||||||||||||||
Zigby Manufacturing | ||||||||||||||||||||||||
Budgeted Statement of Retained Earnings | ||||||||||||||||||||||||
For the Quarter Ended June 30, 2013 | ||||||||||||||||||||||||
Retained earnings - Beginning Balance | ||||||||||||||||||||||||
Add: Net Income | ||||||||||||||||||||||||
Less: Dividends | ||||||||||||||||||||||||
Retained earnings - Ending Balance ------------------------------------------------------------------------------------------
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started