Earrings Unlimited Case Solution

Submitted By Jambuw
Words: 618
Pages: 3
Open Document
PROJECT A - Case 9-30

Earrings Unlimited

Student Name:

SALES BUDGET:
April

Budgeted unit sales
Selling price per unit
Total Sales

65,000
$10.00
$650,000.00

May

100,000
$10.00
$1,000,000.00

Percentage of sales in the month of sale
Percentage of sales in the month after the sale
Percentage of sales in the second month after sale
Cost Per Pair of Earrings
Purchase Payment schedule

June

50,000
$10.00
$500,000.00

Quarter

215,000
$10.00
$2,150,000.00

20.00%
70.00%
10.00%
$10.00
50.00%

Actual and Budgeted Sales
January (actual)
February (actual)
March (actual)
April (budget)
May (budget)

20,000
26,000
40,000
65,000
100,000

June (budget)
July (budget)
August (budget)
Sept (budget)

SCHEDULE OF EXPECTED CASH COLLECTIONS:
April

February sales
March sales
April sales
May sales
June sales
Total Cash Collections

$26,000.00
$280,000.00
$130,000.00

$436,000.00

May

$40,000.00
$455,000.00
$200,000.00
$695,000.00

50,000
30,000
28,000
25,000

June

$65,000.00
$700,000.00
$100,000.00
$865,000.00

Quarter

$26,000.00
$320,000.00
$650,000.00
$900,000.00
$100,000.00
$1,996,000.00

MERCHANDISE PURCHASES BUDGET:
April

Budgeted unit sales
Add desired ending inventory
Total needs
Less beginning inventory
Required purchases
Cost of purchases @ $4 per unit
Inventory needed for following month
Cost of purchases per unit

65,000
40,000
105,000
26,000
79,000
$316,000.00

May

100,000
20,000
120,000
40,000
80,000
$320,000.00
40.00%
$4.00

June

50,000
12,000
62,000
20,000
42,000
$168,000.00

Quarter

215,000
12,000
227,000
26,000
201,000
$804,000.00

Assets
Cash
Accounts Receivable ($26,000 February sales;
$320,000 March sales)
Inventory
Prepaid Insurance
Property and Equipment (net)
Total Assets

$74,000.00
$346,000.00
$104,000.00
$21,000.00
$950,000.00
$1,495,000.00

Liabilities and Stockholders' Equity
Accounts payable
Dividends payable
Capital Stock
Retained Earnings
Total liabilities and Stockholders equity

$100,000.00
$15,000.00
$800,000.00
$580,000.00
$1,495,000.00

BUDGETED CASH DISBURSEMENTS FOR MERCHANDISE PURCHASES:
April
May

Accounts payable
April purchases
May purchases
June purchases
Total cash payments

$100,000.00
$158,000.00

$258,000.00

$158,000.00
$160,000.00
$318,000.00

June

$160,000.00
$84,000.00
$244,000.00

Quarter

$100,000.00
$316,000.00
$320,000.00
$84,000.00
$820,000.00

Monthly Operating Expenses
Variable:
Sales commissions
Fixed:
Advertising
Rent
Salaries
Utilities
Insurance
Depreciation

4.00% of Sales
$200,000.00
$18,000.00
$106,000.00
$7,000.00
$3,000.00
$14,000.00
EARRINGS UNLIMITED
CASH BUDGET
FOR THE THREE MONTHS ENDING JUNE 30
April
May

June

Quarter

Total cash available

$74,000.00
$436,000.00
$510,000.00

$50,000.00
$695,000.00
$745,000.00

$50,000.00
$865,000.00
$915,000.00

$174,000.00
$1,996,000.00
$2,170,000.00

Less Disbursements
Merchandise purchases
Advertising

$258,000.00
$200,000.00

$318,000.00
$200,000.00

$244,000.00
$200,000.00

$820,000.00
$600,000.00

Cash balance Min $50,000
Add collections from customers

Rent
Salaries
Commissions
Utilities
Equipment purchases
Dividends paid
Total Disbursements

$18,000.00
$106,000.00
$26,000.00
$7,000.00

Excess (deficiency) of receipts over disbursements
Financing:
Borrowings (maintain 50,000)
Repayments(maintain 50,000)
Schedule
@
1.00%
Interest (Total)
Total financing

Cash balance, ending

$18,000.00
$106,000.00
$40,000.00
$7,000.00
$16,000.00

$18,000.00
$106,000.00
$20,000.00
$7,000.00
$40,000.00

$15,000.00
Show More

Related Documents: Earrings Unlimited Case Solution

Project Name Essay example

Project Name: McDonald’s Delivery Service in SA About the business: McDonald's is the world's leading global food service retailer with over 36,000 locations serving approximately 69 million customers in over 100 countries each day. More than 80% of McDonald's restaurants worldwide are owned and operated by independent local business men and women. McDonald’s goal is to become customers’ favorite place and way to eat and drink by serving core favorite such as their World Famous Fires, Big Mac, Quarter…

Words 1247 - Pages 5

Essay on Max Lionel

Project Planning Templates BSBPMG522A Undertake project work Table of Contents 1.1 – Initiation and scope Project brief Project purpose and rationale The justification and validity of the project needs to be confirmed before the project proceeds. This document is used to clarify the project purpose and justification and to gain approval to proceed to the next phase. Project title Working title. Project purpose Describe the purpose/need/rationale/feasibility for the project. Background…

Words 2872 - Pages 12

2014 Candidate Record Form, Production Log And Assessment Record

2014 Candidate Record Form, Production Log and Assessment Record Level 2 Higher Project (7992) This form should be attached to the candidate’s work and either retained at the centre or sent to the moderator as required. The declarations should be completed as indicated. Centre number Centre name 32115 Bolton Sixth Form College Candidate number Candidate’s full name     Work submitted for assessment must be the candidate’s own. If candidates copy…

Words 2090 - Pages 9

Essay on Project Management and Data Development Plan

educational example of the contract terms and project work plan and deliverables. ENGAGEMENT OF SERVICES BETWEEN NAME OF CLIENT AND NAME OF CONSULTANT The following agreement is between the NAME OF CONSULTANT and NAME OF CLIENT. This agreement confirms our understanding of the terms of our engagement. Description of Services to be Performed: NAME OF CONSULTANT will work with NAME OF CLIENT to plan and design a performance monitoring system for NAME OF CLIENT using the Demonstrating Value Framework…

Words 855 - Pages 4

Description Of High School Involvement

achievements and responsibilities you would like the section committee to consider. Activity/Organization Name ____________________________________________________________ Brief Description of Organization (25 word limit) Date Started Date Ended Leadership Positions Held _____________________________________________________________ Achievements/Responsibilities (50 word limit) Activity/Organization Name ____________________________________________________________ Brief Description of Organization (25…

Words 811 - Pages 4

ASCE MOP On Condition Assessment Of Sewer Lines

Project Name This is the format for the case study and is provided for your information so that you can make a determination if you would like to submit an abstract. At this stage we are only asking for a short abstract. If your abstract is accepted, we will ask you use to use this format to submit your case study. Please provide a summary of your project to be considered for publication in the ASCE MOP on Condition Assessment of Sewer Lines. Limit…

Words 355 - Pages 2

Project Business Objectives Essay

Project Charter for the ProjectName prepared by DocumentAuthor This document template provides the structure for preparing the deliverable for the Project Charter assignment. Project Purpose and Justification Describe the background that led to this project proposal. Why is the project being done? What value will be achieved? Relate to business concerns, like: revenue, market share, cost, risk, service, and customer satisfaction. Project Business Objectives Define specific measurable…

Words 414 - Pages 2

Project Charter: Onsite Be Detector Essay

A. General Information Project Title: Project B: Optical Fluorescence and Laser-Induced Breakdown Spectroscopy Performance for Estimating Beryllium Concentrations in Soils at the Luckey Site Brief Project Description: Using 40 soil samples, we will compare Beryllium measurement strategies to assess the possibility of onsite Be measurement and analysis. Prepared By: Date: 9/22/13 Version: 3.14 B. Project Objective: The purpose of this project is to determine whether real-time…

Words 1294 - Pages 6

project man Essay

$20,000/week after week 65 MICROSOFT PROJECT 2010 CHECK LIST MAN 6581: Project Management: R. Behara PROJECT SETUP  FILE > INFO > PROJECT INFO > ADVANCED PROPERTIES > SUMMARY  FILE > OPTIONS > SCHEDULE  NEW TASKS CREATED > AUTO SCHEDULED  DEFAULT TASK TYPE > FIXED UNITS  NEW TASKS ARE EFFORT DRIVEN > do not select  SPLIT IN-PROGRESS TASKS > do not select  PROJECT > CHANGE WORKING TIME > CREATE NEW CALENDAR  NAME (enter new calendar name) > MAKE COPY OF STANDARD CALENDAR  FOR…

Words 456 - Pages 2

Essay on Project Management and Water Consumption

1. Project Identification Project Name Water Consumption at Waterfront Campus Project Sponsor Darrell Stevens Project Manager Darrell Stevens Version 1.0 2. PROJECT BACKGROUND/CONTEXT There is currently no in depth data on hand for the amount of water used on campus. Our Woodside Wing is Gold in LEED (Leadership in Energy and Environmental Design) and Harbour Wing is Silver. 3. Project OBJECTIVES (purpose) Cut down on the water consumption at the Waterfront campus. Educate student and staff…

Words 758 - Pages 4