Question
Can you find the Break-Even in gallons and dollars. Target Profit in gallons and dollars if the company wants a net operating income of $250,000
Can you find the Break-Even in gallons and dollars. Target Profit in gallons and dollars if the company wants a net operating income of $250,000 after taxes. The tax rate is 20%. Margin of Safety expressed in dollars, units, and as a percentage of sales.
Sharpe Flavored Water Company
The Sharpe Flavored Water Company makes high quality Flavored Water. Management is ready to close the books for the end of the first quarter in 2019 and your supervisor has presented you with the following information.
-
Total sales in gallons of flavored flavored water for January 2019 through March 2019 are as follows:
January 15,000
February 14,000
March 18,000
Each gallon of flavored water is packaged in eight 16 ounce bottles and sold in a case that sells for $15.00 per case. The company produced 49,000 units during the first quarter of 2019.
-
The companys Variable Costs include the following
Direct Materials of $1.50 per gallon
Direct Labor of $____ per gallon (Each gallon of flavored water requires 15 minutes of direct labor time and the wage rate is $8.00 per hour)
Variable MOH $_____per gallon (The variable overhead rate is $2.00 per machine hour and processing one gallon of flavored water takes 45 minutes of machine time)
Variable Selling and Administrative costs of $1.50 per gallon
-
The companys Fixed Costs for the quarter include the following:
Manufacturing Overhead $49,000
Selling and Administrative $31,000
The companys fixed manufacturing overhead per gallon is $______. (The Fixed Manufacturing Overhead rate is based on Fixed Costs for the quarter and the units produced for the quarter.)
-
The companys manufacturing overhead is applied based on the number of gallons produced using the Variable Manufacturing Overhead Rate per gallon calculated in b and the Fixed Manufacturing Overhead Rate per gallon calculated in c.
-
Raw Materials Inventory consists entirely of direct materials and, at the beginning of the year, consists of 700 units of direct material at a cost of $1.50 per unit. The company purchased 48,500 units of direct material at a cost of $1.50 per unit. Each gallon of flavored water requires one unit of direct materials.
-
Beginning Work in process inventory consists of 800 gallons of partially processed flavored water. All raw materials are added at the beginning of the production process and these partially completed units are 70% complete with respect to conversion costs. Ending work in process consists of 900 gallons of partially processed flavored water that are 60% complete with respect to conversion costs. The company completed and transferred out 49,000 units this quarter.
The beginning work in process and current period costs are as follows
Beginning WIP
Direct Materials $1,250
Conversion Costs $2,135
Current period Costs
Direct Materials $74,850
Conversion Costs $220,775
-
There are 300 gallons of flavored water in Finished Goods Inventory at the beginning of the year carried at a cost of $6.00. There are 2,000 gallons in ending Finished Goods Inventory carried at a cost of $6.00 per unit.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started