Part 2 Computer Accessories assembles a computer
|
Beginning-of-year balances |
|||||||
|
Cash |
$50,000 |
||||||
|
Accounts receivables (previous quarter's sales) |
$61,200 |
||||||
|
Raw materials |
653 |
Kits |
|||||
|
Finished Goods |
510 |
Units |
|||||
|
Accounts payable |
$33,255 |
||||||
|
Desired end-of-year inventory balances |
|||||||
|
Raw materials |
500 |
kits |
|||||
|
Finished goods |
270 |
units |
|||||
|
Desired end-of-quarter balances |
|||||||
|
Raw materials as a portions of the following quarter's production |
20% |
||||||
|
Finished goods as a portion of the following quarter's sales |
15% |
||||||
|
Manufacturing costs other than raw materials are paid in month incurred unless it is an noncash expense |
|||||||
|
Variable Standard cost per unit |
Unit of input |
Unit price per input |
Total cost per unit |
||||
|
Raw materials |
1 |
kit |
$50 |
$50 |
|||
|
Direct labor hours at rate |
0.8 |
hour |
$25 |
$20 |
|||
|
Variable overhead/labor hour |
0.8 |
hour |
$10 |
$8 |
|||
|
Total Variable Standard cost per unit |
$78 |
||||||
|
Fixed overhead cost per quarter used cash |
$50,000 |
||||||
|
Manufacturing Depreciation per quarter |
$10,000 |
||||||
|
Selling and administrative costs are paid in month incurred unless it is an noncash expense |
|||||||
|
Variable cost per unit |
$6 |
||||||
|
Fixed selling and administrative cost per quarter used cash |
$25,000 |
||||||
|
Selling and administrative depreciation per quarter |
$5,000 |
||||||
|
Additional information: All cash payments except purchases are made quarterly as incurred. |
|||||||
|
Portion of sales collected |
|||||||
|
Collected in the quarter of sale |
75% |
||||||
|
Subsequent quarter |
24% |
||||||
|
Bad debts |
1% |
||||||
|
Portion of purchases paid |
|||||||
|
Paid in the quarter of purchases |
70% |
||||||
|
Subsequent quarter |
30% |
||||||
|
Unit selling price |
$150 |
||||||
|
Sales forecast |
|||||||
|
Quarter |
First |
Second |
Third |
Fourth |
|||
|
Unit sales |
3,400 |
2,500 |
3,000 |
4,100 |
|||
Required: Prepare and answer the following.
1. A sales budget for each quarter and the year.
2. A production budget for finished goods of units each quarter and the year.
3. A purchases budget for raw material of kits each quarter and the year.
4. A manufacturing cost budget for each quarter and the year.
5. A selling and administrative expense budget for each quarter and the year.
6. A cash budget for each quarter and the year.
7. A pro-forma contribution income statement for each quarter and the year.
Hint: You will need to compute Variable Cost of Goods Sold for each quarter, which is unit sold times total Variable Standard cost per unit.
8. Using your information from #7, compute the Breakeven in dollars for the year.
Hint: Compute the annual contribution margin ratio.
9. What if the company is able to lower the fixed Manufacturing overhead costs that uses cash per quarter from $50,000 to $45,000. Which budgets will change and what will be the new annual income?
You should only have to change the fixed manufacturing overhead costs that uses cash on this worksheet and all the appropriate budgets will change on the solution worksheet if you have
set up your cell references correctly. Please make sure you return the Fixed manufacturing overhead costs that uses cash back to the original number before you submit your solution.
In: Accounting
Production Budget
Flashkick Company Manufactures and sells soccer balls for teams of children in elementary and high school. Flashkick's best selling lines are the practice ball line (durable soccer balls for training and practice) and the match ball line (high-performance soccer balls used in games). In the first four months of next year, Flashkick expects to sell the following:
___________Practice Balls_______________________Match Balls
_________Units_________selling price________units________selling price
January ___50,000_________$8.75__________7000___________$16.00
February___58000_________$8.75__________8000___________$16.00
March _____70000_________$8.75_________12000___________$16.00
April______100000_________$8.75_________18000___________$16.00
Flashkick requires ending inventory of product to equal 20 percent of the next month's unit sales. Beginning inventory in January was 3,300 practice soccer balls and 400 match soccer balls.
Required
Construct a production budget for each of the two product lines for Flashkick Company for the first three months of the coming year.
Production budget for practice balls
Flashkick Company
Production Budget - Practice balls
For the first quarter of next year
_________________January______________February__________________March
unit sales____________?__________________?_______________________?
desired ending inventory__?_______________?________________________?
total needed__________?_________________?________________________?
Less: Beginning inventory____?____________?________________________?
unit produced______________?___________?_________________________?
Production budget for match balls:
Flashkick Company
Production Budget - Match Balls
_______________January___________February_______________March
unit sales________?__________________?_____________________?
desired ending inventory___?___________?_____________________?
Total needed_____?__________________?_____________________?
Less: Beginninng inventory____?________?_____________________?
Units produced________?_____________?______________________?
In: Accounting
Overhead Variances, Four-Variance Analysis, Journal Entries
Laughlin, Inc., uses a standard costing system. The predetermined overhead rates are calculated using practical capacity. Practical capacity for a year is defined as 1,000,000 units requiring 200,000 standard direct labor hours. Budgeted overhead for the year is $750,000, of which $300,000 is fixed overhead. During the year, 900,000 units were produced using 190,000 direct labor hours. Actual annual overhead costs totaled $800,000, of which $294,700 is fixed overhead.
Required:
1. Calculate the fixed overhead spending and volume variances.
| Fixed Overhead Spending Variance | $ | Favorable |
| Fixed Overhead Volume Variance | $ | Favorable |
2. Calculate the variable overhead spending and efficiency variances.
| Variable Overhead Spending Variance | $ | Unfavorable |
| Variable Overhead Efficiency Variance | $ | Favorable |
3. Prepare the journal entries that reflect the following:
Note: Close the variances with a debit balance first. For compound entries, if an amount box does not require an entry, leave it blank or enter "0".
| a. | Fixed Overhead Control | ||
| Variable Overhead Control | |||
| Miscellaneous Accounts | |||
| b. | Work in Process | ||
| Fixed Overhead Control | |||
| Variable Overhead Control | |||
| c. | Fixed Overhead Volume Variance | ||
| Variable Overhead Spending Variance | |||
| Variable Overhead Efficiency Variance | |||
| Fixed Overhead Spending Variance | |||
| Fixed Overhead Control | |||
| Variable Overhead Control | |||
| d. | Cost of Goods Sold | ||
| Fixed Overhead Spending Variance | |||
| Variable Overhead Spending Variance | |||
| Variable Overhead Efficiency Variance | |||
| Fixed Overhead Spending Variance | |||
| Cost of Goods Sold |
In: Accounting
8a)
|
Rachel Jackson builds some apartment buildings. This expenditure is __________. |
| fixed investment |
| inventory investment |
| residential consumption |
| durable consumption |
b)
|
__________ goods are goods that are not resold to someone else. |
| Final |
| Transfer |
| Intermediate |
| Consumer durable |
c)
|
Spock is a simple economy in which all income is either compensation of employees or profits. There are no indirect taxes. Using the income approach, GDP is made up of which of the following? |
| Compensation of employees – profits – allowance for depreciation and obsolescence) |
| Compensation of employees – profits + (allowance for depreciation and obsolescence) |
| Compensation of employees + profits + allowance for depreciation and obsolescence) |
| Compensation of employees + profits – allowance for depreciation and obsolescence) |
d)Which of the following would be included in this year’s GDP?
| Last year’s construction of a car factory that will begin production this year |
| This year’s purchase of a share of Ford Motor Corporation’s common stock |
| Next year’s purchase of a car produced this year |
| This year’s purchase of a car produced last year |
e)What is the difference between national income and domestic income?
| Net taxes |
| Capital consumption allowance |
| Payments of factor income to the rest of the world |
| Net payments of factor income to the rest of the world |
In: Economics
Exercise 7-2 Production Budget [LO7-3]
|
Down Under Products, Ltd., of Australia has budgeted sales of its popular boomerang for the next four months as follows: |
| Sales in Units | |||
| April | 78,000 | ||
| May | 85,000 | ||
| June | 118,000 | ||
| July | 94,000 | ||
|
The company is now in the process of preparing a production budget for the second quarter. Past experience has shown that end-of-month inventory levels must equal 20% of the following month’s sales. The inventory at the end of March was 15,600 units. |
| Required: | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Prepare a production budget for the second quarter; in your budget, show the number of units to be produced each month and for the quarter in total.
please show work. Exercise 7-3 Direct Materials Budget [LO7-4]
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
Ajax Corporation issued 1,500 bonds each with face value of $1,000 on January 1, 2025. The bonds have semi-annual interest payments at 4% per annum due on December 31st and June 30th. The bonds mature on December 31, 2029 and were issued to yield 5% per annum. What amount would Ajax record for interest expense when making the first interest payment on June 30, 2025?
Question 7 options:
|
$69,208 |
|
|
$30,000 |
|
|
$31,347 |
|
|
$35,859 |
In: Accounting
Part I. Master Budgets
Farmer Manufacturing, Inc. prepares their budgets on a quarterly basis. Below is information which will be used to prepare their first quarter budget.
Forecasted sales in units for each product are as follows:
|
January |
February |
March |
|
|
Product A |
22,000 units |
25,000 units |
33,000 units |
The average selling price is $36 per unit.
Below is additional information which will be needed to prepare the master budget:
Company policy requires that each month’s ending inventory (finished goods) be equal to 40% of the next month’s estimated sales. Ending inventory on December 31 was 8,800 units. Sales for April are projected to be 39,000 units, and sales for May are projected to be 42,000 units.
Information on material and labor requirements include:
|
Product A |
|
|
Ingredient Q (per unit) |
3 pounds |
|
Price: Ingredient Q |
$2.75 per pound |
|
Direct labor hours (per unit) |
0.70 |
|
Direct labor rate per hour |
$16.00 |
Company policy requires that the ending inventory for raw material be equal to 30% of the following month’s estimated material requirements. Ending inventory on December 31 for Ingredient Q was 20,800 pounds.
Manufacturing overhead includes both variable and fixed components. Overhead is allocated based on direct labor hours. Variable overhead is budgeted at $3.25 per direct labor hour required. Fixed overhead is budgeted at $34,500 per month.
Selling expenses include sales commissions and sales salaries. Commissions are paid at 4% of sales. Monthly sales salaries are $4,200. General and administrative expenses are $6,400 per month.
Part I Requirements:
In: Accounting
Many observers considered the race riots of the 1960s a negative social phenomenon. However, in a 1967 speech, Martin Luther King Jr. reflected that: Urban riots must now be recognized as durable social phenomena. They may be deplored, but they are there and should be understood. Urban riots are a special form of violence. They are not insurrections. The rioters are not seeking to seize territory or to attain control of institutions. They are mainly intended to shock the white community. They are a distorted form of social protest. The looting which is their principal feature serves many functions. It enables the most enraged and deprived Negro to take hold of consumer goods with the ease the white man does by using his purse. Often the Negro does not even want what he takes; he wants the experience of taking. But most of all, alienated from society and knowing that this society cherishes property above people, he is shocking it by abusing property rights. There are thus elements of emotional catharsis in the violent act. Briefly explain how sociologists define social problems. Then, using MLK’s analysis of race riots as an example, discuss the importance of approaching social problems objectively.
In: Psychology
Problem 9-4
Karam Inc. has compiled the following data in order to put together their first quarter operating budget for 2011:
| January | February | March | April | |
| Sales (units) | 35,000 | 31,000 | 38,000 | 29,000 |
Each unit requires three hours of direct labor.
Additional information:
Karam sells each unit for $95.
Company policy is to have 30 percent of next month's sales (in
units) in ending finished goods inventory.
Company policy is to have 40 percent of next month's production
needs in ending raw materials inventory. The production needs for
April is 95,500.
It takes three pounds of material to produce each unit and the cost
is $2.75/pound.
Required:
A. Prepare a sales budget for the January, February and March and for the first quarter in total.
| Karam Inc. | ||||
| Sales Budget | ||||
| For the Quarter Ended March 31, 2011 | ||||
| January | February | March | Total | |
| Sales in units | ||||
| Unit selling price | $ | $ | $ | $ |
| Budgeted sales | $ | $ | $ | $ |
B. Prepare a production budget for January, February and March and for the first quarter in total.
| Karam Inc. | ||||
| Production Budget | ||||
| For the Quarter Ended March, 31, 2011 | ||||
| January | February | March | Total | |
| Sales in units (given) | ||||
| Desired ending inventory | ||||
| Total needs | ||||
| Less: Beginning inventory | ||||
| Units to be produced | ||||
C. Prepare a direct materials purchases budget for January, February and March and for the first quarter in total.
| Karam Inc. | ||||
| Production Budget | ||||
| For the Quarter Ended March 31, 2011 | ||||
| January | February | March | Total | |
| Units to be produced | ||||
| Direct materials per unit | ||||
| Production needs | ||||
| Desired ending inventory | ||||
| Total needs | ||||
| Less: Beginning inventory | ||||
| Direct materials to be purchased | ||||
| Cost per pound | $ | $ | $ | $ |
| Total purchase cost | $ | $ | $ | $ |
In: Accounting
Tami Tyler opened Tami’s Creations, Inc., a small manufacturing company, at the beginning of the year. Getting the company through its first quarter of operations placed a considerable strain on Ms. Tyler’s personal finances. The following income statement for the first quarter was prepared by a friend who has just completed a course in managerial accounting at State University.
Reconcile the variable and absorption costing net operating income (loss) figures. (Losses and deductions should be entered as a negative.)
|
|||||||||
During the second quarter of operations, the company again produced 33,400 units but sold 38,400 units. (Assume no change in total fixed costs.) What is the company’s variable costing net operating income (loss) for the second quarter?
|
||||||||||||||||||||||||||||||||||||||||||||||
|
Tami’s Creations, Inc. Income Statement For the Quarter Ended March 31 |
||||||
| Sales (28,400 units) | $ | 1,136,000 | ||||
| Variable expenses: | ||||||
| Variable cost of goods sold | $ | 445,880 | ||||
| Variable selling and administrative | 194,540 | 640,420 | ||||
| Contribution margin | 495,580 | |||||
| Fixed expenses: | ||||||
| Fixed manufacturing overhead | 323,980 | |||||
| Fixed selling and administrative | 195,850 | 519,830 | ||||
| Net operating loss | $ | ( 24,250) | ||||
In: Accounting