Superior Company has the following cost and expense data for the year ending December 31, 2017.
|
Instructions
|
(a) |
Prepare a cost of goods manufactured schedule for Superior Company for 2017. |
|
(b) |
Prepare an income statement for Superior Company for 2017. |
|
(c) |
Assume that Superior Company's accounting records show the balances of the following current asset accounts: Cash $17,000, Accounts Receivable (net) $120,000, Prepaid Expenses $13,000, and Short-Term Investments $26,000. Prepare the current assets section of the balance sheet for Superior Company as of December 31, 2017. Action Plan
|
||||||||||||||||||||||||||
In: Accounting
FunKids Sdn Bhd produces a type of toy which is sold for RM120 per
unit. The normal annual production and sales for the toys are 2,800
units, although the company has the capacity to produce up to 3,000
units.
The following data consist of costs incurred during the year ended
2019:
RM
Material (100% variable) 70,000
Labour (70% variable) 80,000
Selling expenses (40% variable) 58,000
Fixed administrative expenses 50,000
The management accountant of the company is proposing the following
alternatives to increase sales for the year 2020 and to reduce the
idle capacity:
1. Reducing the selling price to RM110 per unit which would lead to
an estimated increase in the sales volume by 30%.
2. An increase in sales would result in an increase of variable
labour cost per unit by 15%.
3. Fixed selling expenses is also expected to increase to RM32,500
due to an aggressive advertising and marketing campaign planned to
boost sales.
Required:
a) Determine the following costs in year 2019:
i. Total variable costs per
unit.
ii. Total fixed
costs.
b) Calculate the following in year 2019:
i. Break-even points in units and in
value.
ii. Margin of safety in units and in
value.
iii. The expected sales value if the company targets for a profit
of RM100,000.
c) Advice the management of FunKids Sdn Bhd if the company should
implement the proposed alternative for year 2020. (Show profit
comparison).
(Total: 25 Marks)
Question 2 (Answer)
total variable cost
Material cost =100% variable
Labor cost
selling expenses
fixed administrative expenses
total variable cost per unit
Break even point in units
Break even point in sales
contribution margin ratio
Margin of safety
expected sales value for 100000 profit
Proposed plan
selling price
selling units
variable cost
fixed cost
Income statement
sales
variable cost
In: Accounting
Cost Behavior Analysis in a Restaurant: High-Low Cost
Estimation
Assume a Potbelly’s restaurant has the following information
available regarding costs at representative levels of monthly sales
(meals served):
| Monthly sales in units | |||
|---|---|---|---|
| 5,000 | 7,000 | 10,000 | |
| Cost of food sold | $ 7,500 | $10,500 | $15,000 |
| Wages and fringe benefits | 5,900 | 5,940 | 6,000 |
| Fees paid delivery help | 6,000 | 8,400 | 12,000 |
| Rent on building | 3,500 | 3,500 | 3,500 |
| Depreciation on equipment | 850 | 850 | 850 |
| Utilities | 600 | 640 | 700 |
| Supplies (soap, floor wax, etc.) | 400 | 480 | 600 |
| Administrative costs | 1,200 | 1,200 | 1,200 |
| Total | $25,950 | $31,510 | $39,850 |
(a) Identify each cost as being variable, fixed, or mixed.
| Cost of food sold | AnswerVariableFixedMixed |
| Wages and fringe benefits | AnswerVariableFixedMixed |
| Fees paid delivery help | AnswerVariableFixedMixed |
| Rent on building | AnswerVariableFixedMixed |
| Depreciation on equipment | AnswerVariableFixedMixed |
| Utilities | AnswerVariableFixedMixed |
| Supplies (soap, floor wax, etc.) | AnswerVariableFixedMixed |
| Administrative costs | AnswerVariableFixedMixed |
(b) Use the high-low method to develop a schedule identifying the amount of each cost that is mixed or variable per unit. Total the amounts under each category to develop an equation for total monthly costs.
Round variable cost answers to two decimal places.
| Fixed Costs | Variable Costs | ||
|---|---|---|---|
| Cost of food sold | Answer | Answer | X |
| Wages and fringe benefits | Answer | Answer | X |
| Fees paid delivery help | Answer | Answer | X |
| Rent on building | Answer | Answer | X |
| Depreciation on equipment | Answer | Answer | X |
| Utilities | Answer | Answer | X |
| Supplies (soap, floor wax, etc.) | Answer | Answer | X |
| Administrative costs | Answer | Answer | X |
| Total costs equation | Answer | Answer | X |
* where X = Unit sales
(c) Predict total costs for a monthly sales volume of 8,500
units.
In: Accounting
The S&OP team at Kansas Furniture, has received estimates of demand requirements as shown in the table. Assuming one-time stockout costs for lost sales of
$125125
per unit, inventory carrying costs of
$2525
per unit per month, and zero beginning and ending inventory, evaluate the following plan on an incremental cost basis:Plan B: Vary the workforce to produce the prior month's demand. The firm produced
1 comma 3001,300
units in June. The cost of hiring additional workers is
$3030
per unit produced. The cost of layoffs is
$6060
per unit cut back.
(Enter
all responses as whole numbers.) Note: Both hiring and layoff costs are incurred in the month of the change (i.e., going from production of
1 comma 3001,300
in July to
10001000
in August requires a layoff (and related costs) of
300300
units in August).
|
Month |
Demand |
Production |
Hire (Units) |
Layoff (Units) |
Ending Inventory |
Stockouts (Units) |
|
|
1 |
July |
10001000 |
1,3001,300 |
00 |
00 |
300300 |
00 |
|
2 |
August |
12001200 |
10001000 |
00 |
300300 |
100100 |
00 |
|
3 |
September |
14001400 |
12001200 |
200200 |
00 |
00 |
100100 |
|
4 |
October |
18001800 |
14001400 |
200200 |
00 |
00 |
400400 |
|
5 |
November |
18001800 |
18001800 |
400400 |
00 |
00 |
00 |
|
6 |
December |
18001800 |
18001800 |
00 |
00 |
00 |
00 |
The total hiring cost =
$24,00024,000.
(Enter your response as a whole number.)The total layoff cost =
$18,00018,000.
(Enter your response as a whole number.)The total inventory carrying cost =
$10,00010,000.
(Enter your response as a whole number.)The total stockout cost =
$62,50062,500.
(Enter your response as a whole number.)The total cost, excluding normal time labor costs, for Plan B =
$114,500114,500.
(Enter your response as a whole number.)
Question is complete. Tap on the red indicators to see incorrect answers.
|
Similar Question |
In: Operations Management
Cortez Company is planning to introduce a new product that will sell for $107 per unit. The following manufacturing cost estimates have been made on 20,000 units to be produced the first year: Direct materials $ 800,000 Direct labor 640,000 (= $16 per hour × 40,000 hours) Manufacturing overhead costs have not yet been estimated for the new product, but monthly data on total production and overhead costs for the past 24 months have been analyzed using simple linear regression. The following results were derived from the simple regression and provide the basis for overhead cost estimates for the new product. Simple Regression Analysis Results Dependent variable—Factory overhead costs Independent variable—Direct labor-hours Computed values Intercept $ 110,000 Coefficient on independent variable $ 5.00 Coefficient of correlation .916 R2 .839 Required: a. What percentage of the variation in overhead costs is explained by the independent variable? 83.90% 92.30% 100.70% 75.50% None of the above b. What is the total overhead cost for an estimated activity level of 60,000 direct labor-hours? $410,000 $420,000 $400,000 $430,000 None of the above c. How much is the variable manufacturing cost per unit, using the variable overhead estimated by the regression (assuming that direct materials and direct labor are variable costs)? $82.00 $90.00 $98.00 $74.00 None of the above d. What is the expected contribution margin per unit to be earned during the first year on 20,000 units of the new product? (Assume that all marketing and administrative costs are fixed.) $25.00 $28.00 $30.00 $23.00 None of the above e. What is the manufacturing cost equation implied by these results? Total cost = $640,000 + ($5.00 × Number of units) Total cost = $110,000 + ($107.00 × Number of units) Total cost = $110,000 + ($16.00 × Number of units) None of the above Next Visit question mapQuestion 3 of 5 Total3 of 5
In: Accounting
Prepare a Schedule of Cost of Goods Manufactured and a Schedule of Cost of Goods Sold and Income Statement;
this ie the jouranl entries
Pre-determined manufacturing overhead rate = Total estimated manufacturing overheads / Estimated direct labor hours = = $3600/12 hours = $300 per direct labor hour
Step 2:
| Cost Sheet | ||
| Job # 1 | ||
| Direct materials $ | ||
| Table top | 2000 | |
| Legs ($650 x 4) | 2600 | |
| Drawer | 0 | 4600 |
| Direct labor cost @ $20 per hour | (3x2x$30) | 180 |
| Manufacturing overheads $ | (3x2x$300) | 1800 |
| Total manufacturing cost $ | 6580 | |
Step 3:
| Cost Sheet | ||
| Job # 2 | ||
| Direct materials $ | ||
| Table top | 2000 | |
| Legs ($650 x 4) | 2600 | |
| Drawer | 400 | 5000 |
| Direct labor cost @ $20 per hour | (3 x 1 x $30) | 90 |
| Manufacturing overheads $ | (3 x 1 x $300) | 900 |
| Total manufacturing cost $ | 5990 | |
Step 4:
| Date | Account Titles and Explanation | Debit | Credit |
| 01-Dec | Raw Materials | 20000 | |
| Accounts Payable | 20000 | ||
| (To record raw materials purchased on account) | |||
| 05-Dec | Work in process - Job # 1 | 4600 | |
| Raw Materials | 4600 | ||
| (To record raw materials requisitioned for Job # 1) | |||
| 10-Dec | Work in process - Job # 1 (3 x 2 hours x $30) | 180 | |
| Salaries and Wages payable | 180 | ||
| (To record direct labor cost incurred) | |||
| 10-Dec | Manufacturing overhead | 3000 | |
| Salaries and Wages payable | 3000 | ||
| (To record Factory Supervisor salary incurred) | |||
| 10-Dec | Salaries and Wages expense | 2000 | |
| Salaries and Wages payable | 2000 | ||
| (To record administrative salary incurred) | |||
| 15-Dec | Work in process - Job # 2 | 5000 | |
| Raw Materials | 5000 | ||
| (To record raw materials requisitioned for Job # 2) | |||
| 16-Dec | Manufacturing overhead | 500 | |
| Accounts Payable | 500 | ||
| (To record rent for factory building payable) | |||
| 17-Dec | Advertising expense | 1400 | |
| Accounts Payable | 1400 | ||
| (To record advertising expense payable) | |||
| 20-Dec | Manufacturing overhead (factory equip.) | 150 | |
| Depreciation expense (S&A equip.) | 600 | ||
| Accumulated Depreciation | 750 | ||
| (To record depreciation expense) | |||
| 22-Dec | Work in process - Job # 1 (2 x 3 hour x $300) | 1800 | |
| Manufacturing overhead | 1800 | ||
| (To record manufacturing OH applied to Job # 1) | |||
| 26-Dec | Finished goods | 6580 | |
| Work in process - Job # 1 | 6580 | ||
| (To record cost of Job # 1 completed and transferred to FG) | |||
| 28-Dec | Accounts Receivable | 25000 | |
| Sales Revenue | 25000 | ||
| (To record sale on account) | |||
| 28-Dec | Cost of goods sold | 6580 | |
| Finished goods | 6580 | ||
| (To record cost of sales) | |||
| Sale of Job # 1 | |||
| 31-Dec | Work in process - Job # 2 (3 x 1 hour x $30) | 90 | |
| Salaries and Wages payable | 90 | ||
| (To record direct labor cost incurred) | |||
| 31-Dec | Work in process - Job # 2 (3 x 1 hour x $300) | 900 | |
| Manufacturing overhead | 900 | ||
| (To record manufacturing OH applied to Job # 2) | |||
| 31-Dec | Cost of goods sold | 950 | |
| Manufacturing overhead | 950 | ||
| (To close underapplied overheads) |
answering these questions :
| What is the ending balance for raw materials? | ||||
| 1. What is the ending balance for work in process? | ||||
| 2. What is the ending balance for finished goods? | ||||
| 3. What is the actual manufacturing overhead cost incurred during December before adjustment? | ||||
| 4. What is the total applied manufacturing overhead cost during December before adjustment? | ||||
| 5. What is the unadjusted cost of goods sold? | ||||
| 6. Was the manufacturing overhead for the month of December overapplied/underapplied ? | ||||
| 7. What is the amount of Manufacturing overhead overapplied/underapplied? | ||||
| 8. What is the adjusted cost of goods sold? | ||||
| 9. What is gross margin? | ||||
| 10. What is the total prime cost for Job#1? | ||||
| 11. What is the total conversion cost for job #1? | ||||
| 12. What is the total product cost for job#1? | ||||
| 13. What was the period cost incurred for the month of December? | ||||
| 14. What is the total variable cost incurred for Job #1(assume that all selling and administrative cost and all manufacturing overhead costs are fixed.)? | ||||
| 15. What is the contribution margin for Job #1 (assume that all selling and administrative cost and all manufacturing overhead costs are fixed.)? | ||||
| 16. What would be the actual (not applied) total fixed manufacturing overhead cost incurred for the company for the month if the order in Job #1 is for five tables instead of one table assuming this cost is with in the relevant range? | ||||
In: Accounting
In: Economics
|
The following alphabetic listing displays selected balances in the governmental activities accounts of Westover Village as of June 30, 2017. Assume that beginning net position is $1,753 (in thousands) and that there were no changes in net position during the year other than those reflected in the selected account balances shown. For simplicity, assume that the village does not have business-type activities or component units. |
| WESTOVER VILLAGE | ||
| Governmental Activities | ||
| Selected Account Balances (in thousands) | ||
| For the Year Ended June 30, 2017 | ||
| Debits | Credits | |
| Expenses—Culture and Recreation | 12,462 | |
| Expenses—General Government | 9,681 | |
| General Revenues—Property Taxes | 56,410 | |
| General Revenues—Unrestricted Grants and Contributions | 1,310 | |
| Expenses—Health and Sanitation | 6,958 | |
| Expenses—Interest on Long-term Debt | 6,178 | |
| General Revenues—Investment Earnings | 2,068 | |
| Expenses—Public Safety | 34,954 | |
| Program Revenue—Culture and Recreation—Charges for Services | 4,105 | |
| Program Revenue—Culture and Recreation—Operating Grants | 2,560 | |
| Program Revenue—General Government—Charges for Services | 3,256 | |
| Program Revenue—General Government—Operating Grants | 953 | |
| Program Revenue—Health and Sanitation—Charges for Services | 5,722 | |
| Program Revenue—Public Safety—Capital Grants | 73 | |
| Program Revenue—Public Safety—Charges for Services | 1,308 | |
| Program Revenue—Public Safety—Operating Grants | 1,417 | |
| Special Item—Gain on Sale of Park Land | 3,583 | |
| Prepare a (partial) statement of activities. (Enter your answers in thousands.) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
Three years ago, Vincent Chow completed his college degree. The economy was in a depressed
state at the time, and Vincent managed to get an offer of only $25,000 per year as a bookkeeper. In
addition to its relatively low pay, this job had limited advancement potential. Since Vincent was an
enterprising and ambitious young man, he instead started a business of his own. He was convinced
that because of changing lifestyles, a drive-through coffee establishment would be profitable. He
was able to obtain backing from his parents to open such an establishment close to the industrial
park area in town. Vincent named his business The Cappuccino Express and decided to sell only
two types of coffee: cappuccino and decaffeinated.
As Vincent had expected, The Cappuccino Express was very well received. Within three
years, Vincent had added another outlet north of town. He left the day-to-day management of each
site to a manager and turned his attention toward overseeing the entire enterprise. He also hired an
assistant to do the record keeping and other selected chores.
REQUIRED
a. Develop an organization chart for The Cappuccino Express.
b. What factors can be expected to have a major impact on the success of The Cappuccino
Express?
c. What major tasks must Vincent undertake in managing The Cappuccino Express?
d. What are the major costs of operating The Cappuccino Express?
e. Vincent would like to monitor the performance of each site manager. What measure(s) of
performance should he use?
f. If you suggested more than one measure, which of these should Vincent select if he could use
only one?
g. Suppose that last year, the original site had yielded total revenues of $146,000, total costs
of $122,000, and hence, a profit of $24,000. Vincent had judged this profit performance to
be satisfactory. For the coming year, Vincent expects that due to factors such as increased
name recognition and demographic changes, the total revenues will increase by 20 percent to
$175,200. What amount of profit should he expect from the site? Discuss the issues involved
in developing an estimate of profit.
In: Accounting
Python Programming- 9.12 S80 MT Practice 2
"""
Enhance your simple food receipt
a. Ask the user for inputs about two food items using the following
prompts in turn [add a space after each
question mark]. Do not forget to assign each user
entry to a unique variable name (do not display the Note to add a
space just use print() to add a space between each
set of input statements):
Name 1? [add a space after the question mark]
Price 1? [add a space after the question mark]
Quantity 1? [add a space after the question mark]
[Note: add space here using print()]
Name 2? [add a space after the question mark]
Price 2? [add a space after the question mark]
Quantity 2? [add a space after the question mark]
[Note: add space here using print()]
Name 3? [add a space after the question mark]
Price 3? [add a space after the question mark]
Quantity 3? [add a space after the question mark]
[Note: add space here using print()]
b. Convert the price and quantity variables to floats
c. Calculate the total cost for the order by calculating each
item's total price by
multiplying price and quantity for each item and then adding up the
total prices for the three items
d. Calculate the total cost plus tax for the order by multiplying
the total cose calculated in c by the tax
rate of .0545 (5.45 percent tax) then adding the tax to the total
cost
e. Display the results using the structure below. Edit the format
string "${:,.2f}".format(identfier) to format the
results of your calculation as currency with the NTD currency type,
a space between NTD and the calculated costs,
and 3 decimal places:
Summary of Charges
You ordered: [Item Name 1] [Item Name 2] [Item Name 3]
Your cost: [total price for all items calculated in 3c above,
formatted with NTD currency, a space & 3 decimal places]
Your cost w tax: [total cost plus tax calculated in 3d above,
formatted with NTD currency, a space & 3 decimal places]
"""
#Start your code below
In: Computer Science