Posts

Which country suffers most from eczema? How clothing is important? What type of cloth protects from Eczema and what is the role of fabric in eczema? How does the industry look? How much money in this industry, is it profitable?

CAP stone 611

Fings to do under the Market Analysis

1 Comparison Chart of the three fabrics – Silver Ion, Bamboo Fabric, Cotton Fabric

– Feature, Advantage, Benefit (FAB) Model for all three fabrics

2 Logistic Model

* Cost Benefit Analysis

– Which Route would work best?

– Consider the tariffs

– Production in USA itself?

– Import from Vietnam or Taiwan?

3. Industrial Analysis

– Find numbers, stats, charts, regarding children with eczema and how clothing is important

– Which country suffers most from eczema?

– How clothing is important?

– What type of cloth protects from Eczema and what is the role of fabric in eczema?

– How does the industry look? How much money in this industry, is it profitable?

– Is it a good opportunity?

– Who buys these types of clothes? primary target?

4. Customer Analysis

Determine your purpose. …

Research the state of the industry. …

Identify your target customer. …

Understand your competition…. (who they are? what price? what is their USP? How they sell it? Their strengths?

Gather additional data. …

Analyze your data. …

Put your analysis to work

Derive AV for this circuit assuming RL=∞, draw the transfer function on the first plot above, and label AV. Explain whether you expect clipping or not.

MOSFETs and BJTs

This is a small-signal problem built up towards a transfer function. Suppose the MOSFETs drawn have ID=1 mA when VGS=2.5 V, and Vth=0.5 V.

(a) Derive AV for this circuit assuming RL=, draw the transfer function on the first plot above, and label AV. Explain whether you expect clipping or not.

(b) Derive AV for this circuit assuming RL=50Ω, draw the transfer function on the second plot above, and label AV.

(c) Derive AV for this circuit assuming RL=50Ω and a coupling capacitor C, draw the transfer function on the third plot above, and label AV.

Watch the instructor selected short video clip and write a two page reflection paper on the video.

Reflection Paper #1

  • https://blackboard.indianatech.edu/bbcswebdav/pid-3130411-dt-content-rid-42537481_1/xid-42537481_1

Students are to watch the instructor selected short video clip and write a two page reflection paper on the video. The paper should contain a reflection (summary) of the video and 2 significant points of impact on them (key ideas). Student are to write a no more than 2 page reflection and discussion of the points from the video. You need to incorporate information from both the video and course readings/discussions into your APA formatted paper.

In a recent poll, 260 people were asked if they liked dogs, and 29% said they did. Find the Margin of Error for this poll, at the 99% confidence level. Give your answer to four decimal places if possible.

RECENT POLL

In a recent poll, 260 people were asked if they liked dogs, and 29% said they did. Find the Margin of Error for this poll, at the 99% confidence level. Give your answer to four decimal places if possible.

Evaluate the claim that ‘the purpose of social psychology is all about influencing the thoughts, feelings, and behaviors of others”. Consider what is meant by the claim and then present evidence that supports the arguments.

Purpose of social psychology

Evaluate the claim that ‘the purpose of social psychology is all about influencing the thoughts, feelings, and behaviors of others”. Consider what is meant by the claim and then present evidence that supports the arguments.

Write up a brief conclusion on your scenario analysis result in the sheet of Scenario Analysis, below the summary report. Which scenario will bring the company the optimum outcome of 2017 sales?

MIS 303 Spring 2023

Excel Assignment – Instructions

In this assignment, you are to follow the instructions to complete and submit the assignment as individuals. Please make sure you follow the instructions closely and complete all tasks on multiple worksheets.

  1. Download the file Excel Assignment.xlsx from to your computer.
  2. Rename the file as YourFirstNameYourLastName.xlsx. You should fill your own first and last names to replace the parts of YourFirstName and YourLastName in the file name. E.g., John-Smith.xlsx
  3. Open the file using Excel 2016. Rename the worksheets as suggested below. In the following instructions, each worksheet will be referred with the new name only.
Sheet1    à 2016 Orders
Sheet2    à Income Statements
Sheet3    à Pivot Tables
Sheet4    à Business Charts
Sheet5    à Goal Seek
Sheet6    à Solver Analysis
  1. On the sheet of 2016 Orders, complete the following tasks.
    1. Make of list on the entire dataset.
    2. Sort the dataset by Product first and then by Region. (Other idea: By Salesperson first and then by Month)
    3. Add a column at the right of Product. Name it Price. Use vLookup function to pull product prices from the sheet Income Statements (D4:D7) and show prices for all orders.
    4. Add a column at the right of Unit. Name it Total. The order totals = Price * Unit.
    5. At the right of Total, add a column called Discount. Use a nested If function to decide the discounts. The company gives 10% discount to all orders from the West region, and the other regions only enjoy 10% discount in December.
    6. At the right of Discount, add a column called Totalw/Dis. It is the order totals – discounts.
    7. In cell L2, use the AVERAGE function to calculate the average number of units sold from the column Unit. Next, use conditional formatting tool and highlight the orders with unit sold greater than average unit sold. Select the green fill and dark green text color option if the cells meet this rule.
  2. On the sheet of Income Statements, complete all the green-colored cells using Excel functions or formulae.
  • Revenueis Units Sold * Unit Price and COGS is Units Sold * Unit Cost.
  • Total Revenueis the sum of the revenues for all products.
  • Total COGSis the sum of the COGS for all products.
  • Gross ProfitTotal Revenue – Total COGS
  • Salariesis 12% of Total Revenue
  • Advertisingis 4% of Total Revenue
  • Miscellaneous expenses are 1% of Total Revenue
  • Total Operating ExpenseSalaries + Advertising + Miscellaneous
  • Earning Before TaxesGross Profit – Total Operating Expense
  • Calculate Taxesbased on tax rate of 25% of Earning Before Taxes
  • Net ProfitEarnings Before Taxes – Taxes
  1. On the sheet of Pivot Tables, create a pivot table. You should start with the sheet of 2016 Orders as it contains all your raw data. But when you choose the location to place your pivot table, make sure you choose an existing sheet – the sheet of Pivot Tables, and click on the cell A1 to place the pivot table separately. Here are some suggested ideas for pivot tables.
  • Product sales by Salespersons
  • Seasonal sales by Regions

Requirements

– Add meaningful title for your pivot table

– Use proper grouping fields and summary fields.

– Use proper structure of the pivot table to ensure readability

– Use proper type and format for summarized values

– Add a short paragraph below or on the side of the pivot table and describe 3 major findings from this table.

  1. On the sheet of Business Charts, create two charts using the summary data provided. Suggested ideas are:

– Salesperson performance

– Monthly sales

– Regional sales, etc.

Requirements

– Use proper chart type based on your data and purposes.

– Add meaningful chart title

– Use proper labels and/or legend to ensure readability

– Add a short paragraph below the charts and describe your major findings from each chart.

 

  1. On the sheet of Goal Seek, find the way to achieve your 2017 profit goals.
    1. Go back to Income Statement It must be completed by now. Copy the gray area (A3:G23). Go to the sheet of Goal Seek, and paste it at the cell A3.
    2. At the blank Rows 1 & 2, merge some cells and add a title 2017 Sales Estimates.
    3. The cell J3 should show a label Price Increasing Rate:, and J4 should show 5%. If they are not there because of your copying and pasting, please add them to your sheet at proper locations.
    4. Edit your data sheet and include 5% increase on Unit Price of all products. Make sure you use formula with reference to J4, where it shows the increasing rate of prices.
    5. Use the Goal Seek tool and see if we want to achieve a $125,000 net profit, what is the increasing rate of price we should apply in 2017?
  2. Scenario Analysis: Go back to the sheet of Income Statement. Use the scenario manager to create three scenarios stated below and create a scenario summary, which will be a separate worksheet.
    1. You will create 3 different scenarios by changing the product pricing mix in order to determine their impacts to Net Profit.
  • The First Scenario is to raise the price of Product B by $5.00. However, this would cause sales of Product B to fall by 800 units and sales of Product C to increase by 700 units. Title the scenario name as Product B Price Change
  • The Second Scenario is to raise the price of Product C by $4.00. However, this would cause sales of Product C to fall by 550 units and sales of Product B to increase by 400 units. Title the scenario name as Product C Price Change
  • The Third Scenario is to raise the price of both Product B and Product C by $6.00. This would cause sales for Products B and C to both decrease by 350 units each. Title the scenario name as Product B and C Price Changes
    1. Create a Scenario summary report, which will become a new and separate worksheet. Make sure the Results Cells include Earnings Before Taxes and Net Profit. Rename this worksheet as Scenario Analysis, and move the sheet to the right of the sheet of Goal Seek.
    2. Write up a brief conclusion on your scenario analysis result in the sheet of Scenario Analysis, below the summary report. Which scenario will bring the company the optimum outcome of 2017 sales?

 

  1. Solver:
    1. Go back to Income Statement It must be completed by now. Copy the gray area (A3:G23). Go to the sheet of Solver Analysis, and paste it at the cell A3.
    2. At the blank Rows 1 & 2, merge some cells and add a title 2017 Income Statement Projections
    3. Change the label Unit Sold (at the cell C3) to Units to Sell.
    4. Within the Solver Analysis worksheet, input the following Solver Parameters:
  • Objective cell: Net Profit (C22) to the value of $80,000.
  • Constraint 1: Product A must sell at least 6000 units
  • Constraint 2: Total Operating Expenses is less than or equal $215,000.
  • Constraint 3: All unit sold quantities (C4:C7) are integers.
    1. Write up a brief conclusion on the major findings from the solver analysis.

Based on a simple and relatively small dataset, provide essential summary information and visualization of this dataset (500 richest people in 2021).

Descriptive Statistics

Descriptive Statistics: Based on a simple and relatively small dataset, provide essential summary information and visualization of this dataset (500 richest people in 2021).
Finding relevant descriptive variables is perforce a creative endeavor try different things, and see what works best
“Works best” here translates into highlighting the most poignant characteristics for this group
Context is King: data only become relevant in context what are suitable and useful yardsticks to compare against?? Industry, Geography, etc.
Optional reading: https://tombreur.wordpress.com/2016/08/31/contextisking/

Capacity and Defenses-You can cite cases, any other type of publication, including: Journals, Books, Internet Articles, etc.

Capacity and Defenses (Mental Impairment or Insanity, Infancy and Immaturity, etc.)

You can cite cases, any other type of publication, including: Journals, Books, Internet Articles, etc.

The paper must:
• Have 8-10 pages not including the title page or sources page.
• Be double-spaced
• Include 1.25 inch margins

• A title page
• An introduction
• Body of paragraphs with subheadings
• Conclusion
• A reference page with at least 10 cited works
Of the total works cited, half should be from academic journals or books published by an academic press. Works cited and the references should be in APA format (details of the APA format can be found at http://www.docstyles.com). The subject of the paper must be any subject matter related to Criminal Justice. (You can cite cases, or any other type of publication.) Policy Paper will be worth a Maximum of 10 points.

Choose an AUDIO example (not video clip) from Unit 3: Indonesia and write a 160 word journal about it.

Indonesia Listening Journal

Choose an AUDIO example (not video clip) from Unit 3: Indonesia and write a 160 word journal about it. Utilize the listening guides in your textbook for this assignment. Include information about the audio example including the genre or style, instruments and form. What culture creates this music? What behaviors or activities are associated with this music? Also include your personal thoughts or feelings about your chosen audio example. Do you like it/dislike it? Why did you choose this particular example?

Address at least two posts of your classmates. Read your classmates’ posts and compose at least two responses (min. 200 words each) to your classmates’ original post.

3: Discussion

In addition, you are required to address at least two posts of your classmates. Read your classmates’ posts and compose at least two responses (min. 200 words each) to your classmates’ original post. Your comments need to be substantive, well-written and critical. You have to use at least 2 readings in your comment. Note that the APA style applies to your answers and comments.

When posting on DB, you should:

  • Make posts that are on topic and within the scope of the course material;
  • Take your posts seriously and review and edit your posts before sending;
  • Be as brief as possible while still making a thorough comment;
  • Always give proper credit when referencing or quoting another source;
  • Be sure to read all messages in a thread before replying. Do not repeat someone else’s post without adding something of your own to it;
  • Avoid short, generic replies such as, “I agree.” You should include why you agree or add to the previous point;
  • Always be respectful of others’ opinions even when they differ from your own. When you disagree with someone, you should express your differing opinion in a respectful, non-insulting way.