Chapter 1: Using Excel to Make Decisions at Current Designs Part 1
Required
Part 1 (a)
Managers Primary Information Needs
Diane Buswell, Controller
Dave Thill, Kayak Plant Manager
Part 1 (b)
Manager Name of report
How frequently
should it be issued?
Mike Cichanowski
Diane Buswell
Deb Welch
Bill Johnson
Dave Thill
Rick Thrune
Part 1 (c)
Payee Purpose
Direct
Materials
Direct Labor
Manufacturing
Overhead
Period Costs
Winona Agency
Property insurance for the
manufacturing plant
Bill Johnson (sales manager)
Payroll check—payment to
sales manager
Xcel Energy
Electricity for manufacturing
plant
Product Costs
Follow the step-by-step directions to answer the questions below, and to format the data table and classify the costs for Current Designs.
Information report would contain
Winona Printing
Price lists for salespeople
Jim Kaiser (sales representative)
Sales commissions
Dave Thill (plant manager)
Payroll check—payment to
plant manager
Dana Schultz (kayak assembler)
Payroll check—payment to
kayak assembler
Composite One
Bagging film used when
kayaks are assembled; it is
North American Composites
Kevlar® fabric for composite
kayaks
Waste Management
Trash disposal for the
company office building
None
Journal entry to record
depreciation of
manufacturing equipment
discarded after use
Shop supplies—brooms,
paper towels, etc.
Polyethylene powder which
is the main ingredient for the
rotational molded kayaks
Property taxes on
manufacturing plant
Chapter 1: Using Excel to Make Decisions at Current Designs Part 2
Required
Current Designs estimated the following product costs for an order from Special Sports:
Direct materials used in production
$ 15,400
Direct labor
11,200
Indirect materials
1,200
Follow the step-by-step directions to format the cost of production report that appears below.
Product Costs for the Special Sports’ Order
4,300