Sales and Manfuacture Overhead Budgets
Not what you're looking for?
How to calculate manufacturing overhead budget and sales budget?
Zeller Electronics Inc. produces and sells two models of pocket calculators, XQ-103 and XQ-104. The calculators sell for $12 and $25, respectively. Because of the intense competition Zeller faces, management budgets sales semiannually. Its projections for the first 2 quarters of 2008 are as follows.
Unit Sales
Product Quarter 1 Quarter 2
XQ- 103 20,000 25,000
XQ-104 12,000 15,000
No changes in selling prices are anticipated.
Instructions
Prepare a sales budget for the 2 quarters ending June 30, 2008. List the products and show for each quarter and for the 6 months, units, selling price, and total sales by product and in total.
ZELLER ELECTRONICS INC.
Sales Budget
For the Six Months Ending June 30, 2008
Quarter 1
Product Units Selling Price Total Sales
XQ-103
$
$
XQ-104
Totals
$
Quarter 2
XQ-103
$
$
XQ-104
Totals
$
Six Months
XQ-103
$
$
XQ-104
Totals
$
For Justus Inc. variable manufacturing overhead costs are expected to be $20,000 in the first quarter of 2008 with $4,000 increments in each of the remaining three quarters. Fixed overhead costs are estimated to be $35,000 in each quarter. Prepare the manufacturing overhead budget by quarters and in total for the year.
JUSTUS INC.
Manufacturing Overhead Budget
For the Year Ending December 31, 2008
Quarter
1 2 3 4 Year
Variable costs $
$
$
$
$
Fixed costs
Total manuf. overhead $
$
$
$
$
Palermo Wholesalers is preparing its merchandise purchases budget. Budgeted sales are $400,000 for April and $475,000 for May. Cost of goods sold is expected to be 60% of sales. The company's desired ending inventory is 20% of the following month's cost of goods sold. Compute the required purchases for April.
$
Purchase this Solution
Solution Summary
The solution explains how to prepare various budgets
Solution Preview
Please see the attached file.
ZELLER ELECTRONICS INC.
Sales Budget
For the Six Months Ending June 30, 2008
Quarter 1
Product Units Selling Price Total Sales
XQ-103 20,000 12 240,000 Total sales = units X selling price
XQ-104 12,000 25 300,000
Totals 32,000 540,000
...
Purchase this Solution
Free BrainMass Quizzes
Situational Leadership
This quiz will help you better understand Situational Leadership and its theories.
Managing the Older Worker
This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce
Change and Resistance within Organizations
This quiz intended to help students understand change and resistance in organizations
Social Media: Pinterest
This quiz introduces basic concepts of Pinterest social media
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.