Questions
Budgeted Income Statement and Supporting Budgets The budget director of Birds of a Feather Inc., with...

Budgeted Income Statement and Supporting Budgets

The budget director of Birds of a Feather Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for January:

  1. Estimated sales for January:
      Birdhouse 6,000 units at $55 per unit
      Bird feeder 4,500 units at $75 per unit
  2. Estimated inventories at January 1:
    Direct materials:
      Wood 220 ft.
      Plastic 250 lb.
    Finished products:
      Birdhouse 300 units at $23 per unit
      Bird feeder 240 units at $34 per unit
  3. Desired inventories at January 31:
    Direct materials:
      Wood 180 ft.
      Plastic 210 lb.
    Finished products:
      Birdhouse 340 units at $23 per unit
      Bird feeder 200 units at $34 per unit
  4. Direct materials used in production:
    In manufacture of BirdHouse:
      Wood 0.80 ft. per unit of product
      Plastic 0.50 lb. per unit of product
    In manufacture of Bird Feeder:
      Wood 1.20 ft. per unit of product
      Plastic 0.75 lb. per unit of product
  5. Anticipated cost of purchases and beginning and ending inventory of direct materials:
      Wood $8.00 per ft.
      Plastic $1.20 per lb.
  6. Direct labor requirements:
    Birdhouse:
      Fabrication Department 0.20 hr. at $15 per hr.
      Assembly Department 0.30 hr. at $12 per hr.
    Bird Feeder:
      Fabrication Department 0.40 hr. at $15 per hr.
      Assembly Department 0.35 hr. at $12 per hr.
  7. Estimated factory overhead costs for January:
    Indirect factory wages $80,000
    Depreciation of plant and equipment 25,000
    Power and light 8,000
    Insurance and property tax 2,000
  8. Estimated operating expenses for January:
    Sales salaries expense $90,000
    Advertising expense 20,000
    Office salaries expense 18,000
    Depreciation expense—office equipment 800
    Telephone expense—selling 500
    Telephone expense—administrative 200
    Travel expense—selling 5,000
    Office supplies expense 250
    Miscellaneous administrative expense 450
  9. Estimated other income and expense for January:
    Interest revenue $300
    Interest expense 224
  10. Estimated tax rate: 30%

Required:

1. Prepare a sales budget for January.

Birds of a Feather Inc.
Sales Budget
For the Month Ending January 31
Unit Sales
Volume
Unit Selling
Price
Total Sales
Birdhouse
Bird feeder
Total revenue from sales $

2. Prepare a production budget for January.

Birds of a Feather Inc.
Production Budget
For the Month Ending January 31
Units
Birdhouse Bird Feeder
Expected units to be sold
Plus desired inventory, January 31
  Total
Less estimated inventory, January 1
Total units to be produced

3. Prepare a direct materials purchases budget for January.

Birds of a Feather Inc.
Direct Materials Purchases Budget
For the Month Ending January 31
Wood Plastic Total
Required units for production:
  Birdhouse
  Bird feeder
Plus desired units of inventory, January 31
Total
Less estimated units of inventory, January 1
Total units to be purchased
Unit price $ $
Total direct materials to be purchased $ $ $

4. Prepare a direct labor cost budget for January.

Birds of a Feather Inc.
Direct Labor Cost Budget
For the Month Ending January 31
Fabrication
Department
Assembly Department Total
Hours required for production:
Birdhouse
Bird feeder
Total
Hourly rate $ $
Total direct labor cost $ $ $

5. Prepare a factory overhead cost budget for January.

Birds of a Feather Inc.
Factory Overhead Cost Budget
For the Month Ending January 31
Indirect factory wages
Depreciation of plant and equipment
Power and light
Insurance and property tax
Total $

6. Prepare a cost of goods sold budget for January. Work in process at the beginning of January is estimated to be $29,000, and work in process at the end of January is estimated to be $35,400.

Birds of a Feather Inc.
Cost of Goods Sold Budget
For the Month Ending January 31
Direct materials:
   
   
  Cost of direct materials available for use
   
  Cost of direct materials placed in production
Total manufacturing costs
Total work in process during the period
Cost of goods manufactured
Cost of finished goods available for sale
Cost of goods sold $

7. Prepare a selling and administrative expenses budget for January.

Birds of a Feather Inc.
Selling and Administrative Expenses Budget
For the Month Ending January 31
Selling expenses:
Sales salaries expense
Advertising expense
Telephone expense—selling
Travel expense—selling
Total selling expenses
Administrative expenses:
Office salaries expense
Depreciation expense—office equipment
Telephone expense—administrative
Office supplies expense
Miscellaneous administrative expense
Total administrative expenses
Total operating expenses $

8. Prepare a budgeted income statement for January.

Birds of a Feather Inc.
Budgeted Income Statement
For the Month Ending January 31
Selling and administrative expenses:
Total selling and administrative expenses
Other revenue:
Other expenses:
$

In: Accounting

Complete the following Pharmacotherapy and Medication Assisted Therapy chart. For each "Purpose of Medication," list the...

Complete the following Pharmacotherapy and Medication Assisted Therapy chart. For each "Purpose of Medication," list the name of a medication that is used for the purpose listed. Complete each of the remaining fields for the medication listed.

Purpose of Medication

Name of Medication

Description of Medication

(25 to 50 words)

Benefits of the Medication

(25 to 50 words)

Risks of the Medication

(25 to 50 words)

Application of Medication in Treating Co-Occurring Disorders

(25 to 50 words)

Treat alcohol substance use disorders

Opiate disorders

In: Psychology

Hypothesis: Anti-smoking television PSAs reduces cigarette smoking. Study design: 500 Individuals were randomly assigned to watch...

Hypothesis: Anti-smoking television PSAs reduces cigarette smoking.

Study design: 500 Individuals were randomly assigned to watch a PSA about wearing seat belts (control group) and 532 individuals were randomly assigned to watch a PSA about the dangers of smoking (treatment group). A week after the study, the same individuals were asked to complete a survey. In the control group, 102 people reported smoking cigarettes in the previous week and in the treatment group, 85 people reported smoking cigarettes in the previous week. (15 points)

Determine the appropriate test: z-test or t-test. Explain why you chose that test.

Calculate the appropriate test statistic

Decide whether you should reject the null hypothesis.

In: Math

Is it better for a firm's actual stock price in the market to be under, over,...

Is it better for a firm's actual stock price in the market to be under, over, or equal to its intrinsic value? Would your answer be the same from the standpoint of stockholders in general and a CEO who is about to exercise a million dollars in options and then retire? Explain.

In: Finance

Question 2. A programmer has to develop an instant messaging app used in mobile phone. He...

Question 2.
A programmer has to develop an instant messaging app used in mobile phone. He is considering the computer instruction set architecture of either RISC or CISC and the programming method of either translation or interpretation.
(a) Suggest and justify the most suitable instruction set architecture.
(b) Suggest and justify the most suitable programming method

In: Computer Science

Write a PL/SQL program that prints following: if sum of its digits raised to the power...

Write a PL/SQL program that prints following: if sum of its digits raised to the power n is equal to number itself, where n is total digits in number.

If the Input is: 129, then output of the program will be: 738

In: Computer Science

replacement Individual Assignment for HRM2040 re COVID-19 You must select 10 of the following areas of...

replacement Individual Assignment for HRM2040 re COVID-19

You must select

10

of the following areas of HR.

Legal Compliance

Technology and Human Resources

Job Analysis and Job Design

Human Resources Planning

Recruiting Employee

Selecting Employees

Employee Orientation and Training

Career Development

Performance Management

Equitable Pay Plans

Employee Benefit and Service Plans

Health and Safety

Employee Relations

Management and Labour Relations

For each of the 10 selected areas, you must identify and explain 3 factors or characteristics that would be

considered HR practices of a 21 st

century organization and provide information from where you select those.

In: Operations Management

Database questions: USE THE FOLLOWING SQL CODE TO SOLVE NEXT QUESTIONS: CREATE TABLE ROBOT ( Serial_no...

Database questions:
USE THE FOLLOWING SQL CODE TO SOLVE NEXT QUESTIONS:
CREATE TABLE ROBOT
(
Serial_no INT NOT NULL,
Model VARCHAR(20) NOT NULL,
Manufacturer VARCHAR(20) NOT NULL,
Price INT NOT NULL,
PRIMARY KEY (Serial_no)
);
INSERT INTO ROBOT VALUES (1, 'Scara','Epson', 23200);
INSERT INTO ROBOT VALUES (2, 'ASSISTA','Mitsubishi', 17500);
INSERT INTO ROBOT VALUES (3, 'Lego Mindstorm','NXT', 650);
INSERT INTO ROBOT VALUES (4, 'Yumi','ABB', 40000);
INSERT INTO ROBOT VALUES (5, 'Pepper','Foxconn', 1600);
INSERT INTO ROBOT VALUES (6, 'Humanoid','Honda', 30000);
SELECT * FROM ROBOT ;
/*===================================================*/
CREATE TABLE OPTIONS
(
Serial_Num INT NOT NULL,
Option_name VARCHAR(20) NOT NULL,
Price INT NOT NULL,
PRIMARY KEY (Serial_num, Option_name),
FOREIGN KEY (Serial_num) REFERENCES ROBOT(Serial_no)
);
INSERT INTO OPTIONS VALUES (1, 'Self power', 10000);
INSERT INTO OPTIONS VALUES (1, 'Sense surrounding', 20000);
INSERT INTO OPTIONS VALUES (5, 'Extra Speed', 30000);
INSERT INTO OPTIONS VALUES (2, 'Self power', 40000);
INSERT INTO OPTIONS VALUES (3, 'Motion Balance', 50000);
INSERT INTO OPTIONS VALUES (4, 'Custom look', 60000);
SELECT * FROM OPTIONS;
/*===================================================*/
CREATE TABLE SALESPERSON
(
Salesperson_id INT NOT NULL,
SName VARCHAR(20) NOT NULL,
Phone VARCHAR(20) NOT NULL,
PRIMARY KEY (Salesperson_id)
);
INSERT INTO SALESPERSON VALUES (111, 'Jameco Electronics', '0252354565');
INSERT INTO SALESPERSON VALUES (222,'RobotShop', '0231236455');
INSERT INTO SALESPERSON VALUES (333,'RoboRealm', '0287678790');
SELECT * FROM SALESPERSON ;
/*===================================================*/​
CREATE TABLE SALE
(
Salesperson_id INT NOT NULL,
Serial_no INT NOT NULL,
MyDate DATE NOT NULL,
Sale_Price INT NOT NULL,
PRIMARY KEY (Salesperson_id, Serial_no),
FOREIGN KEY (Salesperson_id) REFERENCES SALESPERSON (Salesperson_id),
FOREIGN KEY (Serial_no) REFERENCES ROBOT(Serial_no)
);
INSERT INTO SALE VALUES (111, 1, DATE'2018-9-23', 22000);
INSERT INTO SALE VALUES (222, 1, DATE'2019-9-22', 21400);
INSERT INTO SALE VALUES (111, 4, DATE'2017-7-21', 37000);
INSERT INTO SALE VALUES (333, 3, DATE'2020-6-14', 470);
SELECT * FROM SALE ;


Q1: Write a query to display all serial numbers of robots that don’t have sales using complex queries

Q2: Write a query that displays the sales price and dynamically assign a deal category to it as follows:
- If the sales price less than or equal 10,000 à accepted-deal price
- If the sales price ranges between 20,000 and 25,000 à average-deal price
- If the sales price greater than 50,000 à rejected-deal price


In: Computer Science

Your job is Supply Chain Management, choose in your field from one of the job search...

Your job is Supply Chain Management, choose in your field from one of the job search sites. Using Word, describe how you would network to get the position you chose. Submit to the Job Search and Networking Folder below.

In: Operations Management

A thermocouple (TC) reads a temperature of 180 degrees C when placed in a large wind...

A thermocouple (TC) reads a temperature of 180 degrees C when placed in a large wind tunnel. The thermocouple is exposed to convection and radiation heat transfer.

  • The convection heat transfer coefficient h = 125 W/m2-K.
  • As for radiation, the surface of the thermocouple is diffuse and gray with an emissivity of 0.6. The walls of the wind tunnel are at a uniform temperature of 450 degrees C.

Questions:

  1. Provide a sketch
  2. State your assumptions
  3. Calculate the temperature of the air in the wind tunnel
  4. The walls of the duct have an emissivity of 0.85. Explain in one or two sentences why the emissivity of the walls should (or should not) have an effect on your answer?

In: Mechanical Engineering

Using matlab Set ASIZE to 5. Write a program that creates an array of ASIZE numeric...

Using matlab

  1. Set ASIZE to 5. Write a program that creates an array of ASIZE numeric elements. Prompt the User for ASIZE numbers and store them in the array. After storing the values, calculate the sum of all the values in the array and display the sum.
  2. Modify the program you wrote for Problem 5 such that it calculates the product of all the values instead of the sum.
  3. Modify the program you wrote in Problem 6 such that it changes the value of each element of the array by multiplying each element of the array by 2, and then displays each element of the array.

                                                                                                              

In: Computer Science

using maxwell eqs show that you can get snells law

using maxwell eqs show that you can get snells law

In: Physics

Discuss Legal trends affecting human resource management (HRM)

Discuss Legal trends affecting human resource management (HRM)

In: Operations Management

Grocery Store using Java Arraylist Requirements: 1. Need Product Class and Stock Class 2. Use arraylist...

Grocery Store using Java Arraylist Requirements:

1. Need Product Class and Stock Class

2. Use arraylist to store/ add product in stock

3. Product must have name, code number and quantity in stock

4. Print list of the products and their stock quantity

5. Search products based on their name

6. Remove product based on their code number

7. Sell product and deduct quantity from stock

8. Stock Class contains methods of search product, add product and check quantity of the product

9. Product Class contains method of get product details

In: Computer Science

I need new and unique answers, please. (Use your own words, don't copy and paste), Please...

I need new and unique answers, please. (Use your own words, don't copy and paste),

Please Use your keyboard (Don't use handwriting) Thank you..

IT101

Q1:Data Modelling is the primary step in the process of database design. Compare and contrast Conceptual data model versus Physical data model. Illustrates with help of example to list down data (entities), relationship among data and constraints on data.

Q2:What strategic competitive benefits do you see in a company’s use of extranets?

Q3:Explain how Internet technologies are involved in developing a process in one of the functions of the business? Give an example and evaluate its business value.

Q4:

What are the basic differences between HRM, Intranet and Internet in terms of Domain and Network Communication Scope?

HRM Intranet

HRM Internet

Domain

Network Communication Scope

In: Computer Science