Posted: April 7th, 2016
Question #1: Please develop a budgeted Income Statement.
Question #2: Complete a cash flow statement on a quarterly bases (assume that annual expenses are evenly dispersed on a quarterly bases) using the information in the attached PDF file.
A. There are 2 products: Car Batteries and Boat Batteries
B. There are 2 sales regions: Southeast and Southwest
C. There are 2 manufacturing divisions: Production and Assembly
D. Sales Prices: Car Batteries-$30.00; Boat Batteries-$35.00
E. There are 2 raw materials for each battery: Plastic and Electrodes
F. Raw materials prices: Plastic-$1.00: Electrodes—$2.00
G. Average Direct Labor Rates (per hour): Production-$4.00; Assembly- $3.00
H. The Manufacturing overhead rates (based on Direct Labor) are Production $2.00; Assembly $1.00
I. The order cost is $15.00
J. The annual carrying cost per unit of inventory is $1.50
K. Product Specification (see attachment for table)
L. Planned Sales (units). Planned Sales (units) (Sales are 95 % cash. The
balance of the sales is received in the following quarter. There is no bad
debt).
(see attachment for table)
M. Inventory Levels (units) – Assume no work in process:
Place an order in 3 easy steps. Takes less than 5 mins.