Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

Overview Successful entrepreneurs understand all aspects of business, especially costs and costing systems. In the course project, you will assume the role of the owner of a small business and apply...

1 answer below »

Overview

Successful entrepreneurs understand all aspects of business, especially costs and costing systems. In the course project, you will assume the role of the owner of a small business and apply managerial accounting principles to evaluate and manage costs related to your services within a costing system. In the first milestone of the project, you will determine and classify the costs necessary for opening your business.

Scenario

You plan to open a business manufacturing collars, leashes, and harnesses for pets. To begin, you will manufacture these in a standard style and size with plans to expand your range over the year. In a few weeks, you will present your company’s financial strategy to some key investors. To begin creating your strategy, you need to consider and record all the costs associated with operating your business. You have decided to use the job order costing system.

Prompt

Use the given operational costs in theMilestone One Operational Costs Data Appendix Word Document to complete the first two tabs, “Cost Classification” and “Variable and Fixed Costs,” in theProject Workbook Spreadsheet.

Specifically, you must address the following rubric criteria:

  • Cost Classification.Accurately classify all your costs in the “Cost Classification” tab of your workbook.
    • Identify direct material, direct labor, overhead, and period costs. (Note: Fixed and variable costs have been classified for you.)
  • Variable and Fixed Costs.Complete the “Variable and Fixed Costs” tab of your workbook. (Note: Some costs are provided for you. Fill in only the missing costs.)
    • Determine your total variable cost per unit and the total fixed costs for each product. Show your work using calculations to the side of the table or using appropriate formulas in the table.

Guidelines for Submission

Submit the Project Workbook with the “Cost Classification” and “Fixed and Variable Costs” tabs completed. This file should be completed and submitted using Microsoft Excel.

Answered 4 days After Sep 06, 2021

Solution

Khushboo answered on Sep 08 2021
142 Votes
Export Summary
        This document was exported from Numbers. Each table was converted to an Excel worksheet. All other objects on each Numbers sheet were placed on separate worksheets. Please be aware that formula calculations may differ in Excel.
        Numbers Sheet Name    Numbers Table Name    Excel Worksheet Name
        Instructions
            Table 1    Instructions
        Instructions - Milestone 1
            Table 1    Instructions - Milestone 1
        Cost Classification
            Table 1    Cost Classification
        Variable and Fixed Costs
            Table 1    Variable and Fixed Costs
        Instructions - Milestone 2
            Table 1    Instructions - Milestone 2
        Contribution Margin Analysis
            Table 1    Contribution Margin Analysis
        Break-Even Analysis
            Table 1    Break-Even Analysis
        Instructions - Milestone 3
            Table 1    Instructions - Milestone 3
        COGS
            Table 1    COGS
        Income Statement
            Table 1    Income Statement
        Variances
            Table 1    Variances
Instructions
    Southern New Hampshire University
    College of Continuing Education (COCE)
    ACC202 - Managerial Accounting
    MILESTONE 1 (Due in Module 2)                MILESTONE 2 (Due in Module 4)                    MILESTONE 3 (Due in Module 5)
    1.                    1.                    1.
        Name                    Choose a price range and calculate:                    Create a Cost of Goods Manufactured Schedule
        Location                    Grooming
        Vision                    Day Care
        Mission                    Boarding
    2.                    2.                    2.
        Identify the following:                    Calculate the
eak-even units                    Create an Income Statement
        Direct Materials                    Grooming                    Revenue will be provided end of week 4
        Diret Labor                    Day Care
        Manufacturing Overhead                    Boarding
        Period Costs                    Calculate the
eak-even for target profits
    3.                        Grooming                3.
                            Day Care
        Calculate the Variable & Fixed Costs for:                    Boarding                    Calculate for the Grooming line:
        Grooming                                        Direct Labor Time Variance
        Day Care                                        Direct Labor Rate Variance
        Boarding                                        Direct Materials Efficiency Variance
                                                Direct Materials Price Variance
&"Cali
i,Regular"&10&K000000ACC202 - MANAGERIAL ACCOUNTING    
Instructions - Milestone 1
    Southern New Hampshire University
    College of Continuing Education (COCE)
    ACC202 - Managerial Accounting
    INSTRUCTIONS FOR MILESTONE 1 (Due Week 2)
    IMPORTANT NOTE:
    Make sure to completely review the Ru
ic for Milestone 1
    Use the data from this Milestone and begin working on your final presentation due in Milestone 4 (Week 7)
    ITEMS TO COMPLETE FOR THIS MILESTONE (Blue Tabs):
    GENERAL
    You plan to open a pet services business that will offer dog grooming, day care and boarding
    COST CLASSIFICATION
    Accurately classify all of your costs (direct material, direct labor, manufacturing overhead, period costs)
    Fixed & Variable cost designation is provided
    VARIABLE & FIXED COSTS
    Determine your per unit cost per dog for grooming, day care and boarding
    OPERATIONAL & COST INFORMATION:
    For simplicity, base all calculations using 30 days in each month
    OPERATIONAL DATA
    Grooming:
    The Groomer can groom 5 dogs a day, 5 days a week
    Each grooming takes 1.5 labor hours
    Day Care:
    The Day Care can house 10 large dogs and 12 small dogs daily.
    Day Care is offered 6 days a week
    Boarding:
    There are 12 kennels (single dog only).
    Boarding (kennel services) is offered every day
    Facilities:
    The Grooming facility is 200 square feet
    The Boarding facility is 2,500 square feet
    The Day Care facility is 1,500 square feet
    General:
    Loan for start-up costs - monthly payment of $420; in effect immediately; limited cash and loan funding - used angel investors
    Modest monthly draw of $600 a month for first year; should be divided evenly amoung the services (grooming, day care, boarding)
    SALARY & HIRING DATA
    Groomer (Allison) - $12.00 an hour, 40 hours a week
    Day Care Attendant (Beverly) - $9.00 per hour, based on need
    Receptionist (Cathie) - $8.50 per...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here