MANproj.pptx

Managerial Accounting -Residency

1

Gimme Cake, LLC

Your team was recently hired as cost accountants for Gimme Cake, LLC. The brainchild efforts of two high school best friend.

NOW.. Their success relies heavy on your team.

2

Gimme Cake, LLC

Applied for Small business loan

Secured 60,000 sq. ft. facility

Revenue - $6.1M

Projected $9.3M – new major customer

Gimme Cake, LLC – Employees & Plant

8 salaried employees + 50 hourly@ $8.50 - $12.50 per hour; based on 40 hours work week.

3 - 4 warehouse workers – 2 shifts/day; 1 supervisor/shift

Plant capacity=$1M/month; with $500K investments in ovens, mixers, etc. can inc. to $1.5M/month

60% of annual volume = Oct to Dec – Overtime and weekends

4

Gimme Cake, LLC 3 Product Line

Singles – served ready to eat

9 inch cake – pre-sliced sold to distributors/food service/stores

10 inch cake – custom labels, plastic domes – can be full cake, duo pack or variety of flavors

5

Gimme Cake, LLC Production Detail

Four-step process – Mixing, filling, baking, processing

Five cake sheets mixed in large batches

Fillings produced in smaller batches, based on schedule

Sheets filled, placed on trays for baking (15-20 at a time)

Cooling, decorating, slicing, packaging, labeling, frozen

Approx. 1 week per order – just in time; goal 1 cake/5 seconds

6

Gimme Cake, LLC Production Line

Three production lines - little difference in flavors/ingredients

Process varies primarily on packaging

Variety packs – labor intensive

Boxes, plastic containers, package tops, labels

Label designs customer provided – vary by order

7

Gimme Cake, LLC Labor Report

Projected # of workers, hours per day, workdays per month * hourly rate

+ Salaried production workers pay

+ Payroll added costs (taxes, FICA, etc.) ________________________________________________

Total Labor Dollars / Projected Sales = Projected Labor %

***Current target projected labor @ 20% of sales

8

Gimme Cake, LLC Overhead Allocation

Currently allocate the same amount of overhead to every output unit

However, owners believe labor and OH vary greatly by product

Since no there is no tracking of labor hours by product, hence the company has no idea of profitability per product line or labor cost

9

Gimme Cake, LLC Select Financial Date – May 2020 Currently **Managing Labor Costs – 20% of sales **Targeting 17% gross margin

10

Other Data

11

Unit Volume = 64,500

Average Operating Assets = $5,500,000

Minimum Rate of Return = 8%

Cost Data

Cost Category (Behavior) May 2020

Sales $766,667

Expenses:

Raw materials (Variable) $327,934

Bakery Labor (Mixed) $158.767

Admin Salaries (Fixed) $41,367

Supplies (Variable) $3,833

Freight/Ship-In (Variable) $4,907

Freight/Ship-Out (Variable) $64,707

12

Cost Data, continued

Cost Category (Behavior) May 2020

Expenses:

Utilities-Electricity (Variable) $9,813

Utilities-Gas(Ovens) (Variable) $3,067

Water (Variable) $920

Repairs & Maintenance (Fixed) $4,293

Rent Expense (Fixed) $19,167

Telephone & Internet (Fixed) $2,300

13

Cost Data, continued

Cost Category (Behavior) May 2020

Expenses:

Co-owners’ Salary (Fixed) $25,300

Brokers’ Commission (Variable) $30,667

TOTAL EXPENSES $697,042

OPERATING PROFIT $69,625

Income Tax $22,280

NET OPRTG INCOME $47,345

14

Your Team Assignment #1

15

What information does Gimme Cake, LLC need? Before recommending a cost system, it is helpful to understand a company’s information needs. Based on the case information, discuss the types of cost information Gimme Cake product costing system should be able to provide.